Changing multiple cells by the same percentage

  • Thread starter Thread starter slindsay
  • Start date Start date
S

slindsay

I have to make a price change, it involves approx. 50 different cells. They
will all increase by 9.25%. Is there a function or a formula that I can use
to change the cells all at once without having to go through and change each
individually?
 
Hi

In an unused cell enter 1.0925 then copy the cell. Select the price cells,
then goto Edit > Paste Special > Select Multiply > OK

Regards,
Per
 
Back
Top