Array function help

English
, , ,
#1

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…

#2

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
image description803×526 92.4 KB

How to create a formula to add a markup price
How do I multiply 1 number to a range of cells?
#3

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

#4

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

#5

Impressum (Legal Info) | Datenschutzerklärung (Privacy Policy)   Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.