Increase the value of as series of cells by 3%

  • Thread starter Thread starter Peter
  • Start date Start date
P

Peter

Hi

I have a columb of values that I need to increse the value of by 3%. Is
there a way to select that columb and increase them?


Cheers Peter
 
Peter said:
Hi

I have a columb of values that I need to increse the value of by 3%.
Is there a way to select that columb and increase them?


Cheers Peter
Click to expand...

Hi Peter,

First back up your file just in case.

Now, enter 1.03 in a spare empty cell somewhere, copy that cell,
select the range of cells to increase, and do:

Edit - Paste special

Select: Formula and Multiply

Click OK.


HTH,

Alan.
 
Back
Top