Ask Your Question
1

Array function help [closed]

asked 2014-01-21 21:20:40 +0100

jr09645 gravatar image

I have a spreadsheet with a table of prices and our prices have gone up. All I want to do is multiply 1.06 to every price in my table B5:Q31 and have result show on same table. Is this possible? Everything I have tried gives me error codes Err:509 or #value...

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2016-02-18 17:40:30.856630

1 Answer

Sort by » oldest newest most voted
2

answered 2014-01-21 22:08:02 +0100

m.a.riosv gravatar image

If I understand what you can, it is possible with paste special.

Put in a cell the value for multiply.
Copy the cell.
Select the range to multiply.
Menu/Paste special/Operations - Multiply.
Ok.

image description

edit flag offensive delete link more

Comments

THANK YOU!! THANK YOU!! THANK YOU!! THAT WORKED AND NOW I CAN UPDATE THIS SO MUCH FASTER! THANK YOU FOR MAKING MY DAY!!!!

jr09645 gravatar imagejr09645 ( 2014-01-21 23:52:06 +0100 )edit

@jr09645 Could you mark the answer as correct by clicking the checkmark?

bencomp gravatar imagebencomp ( 2014-01-23 23:27:31 +0100 )edit

Question Tools

1 follower

Stats

Asked: 2014-01-21 21:20:40 +0100

Seen: 1,112 times

Last updated: Jan 21 '14