? -> Can I multiply a group of cells by a value so that each cell increases by that value?

  • Thread starter Thread starter DH
  • Start date Start date
D

DH

I have a price menu, with unique prices in each cell
from A1 to F20.

Is there a way to select all the cells and then multiply by 10%,
so that each price would show a 10% increase?

Thanks
DH
 
For auditing or safety purposes in case you/somebody apply it incorrectly
there might be a reason to keep the originals, then you could just do

=A1*1.1
and copy down and across in another area using the mouse, otherwise you
could put 1.1 in an empty cell, copy it, select the table and do edit>paste
special and select multiply
 
Back
Top