How do I increase a table values by 1.2 for example?

M

Michal

I have a table with quarters in rows and values in columns. I need to
increase all values by some factor (lets say number in cell A1). I know that
I can multiply every cell separatelly. Is there any other, more automatic way?
 
A

Anne Troy

Copy a cell that contains the value 1.2. Now select all the cells you want
to increase. Hit Edit-->Paste special, Multiply.
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


Michal said:
I have a table with quarters in rows and values in columns. I need to
increase all values by some factor (lets say number in cell A1). I know that
I can multiply every cell separatelly. Is there any other, more automatic
Click to expand...
way?
 
M

Michal

Well OK, but I would like to have pasted the A1 cell instead of 1.2 value
into selected cells, so if I change the A1 value from 1.2 to 1.5 all selected
cells will be multiplied by this factor.
 
Top