Increasing and decreasing numbers by 5% ....also showing a loss

[Karen]

I need to increase my spreadsheet by 5% for 3 years and also some of my
colums I need to show a decrease of 5%. Help please!

 

[Joe User]

I need to increase my spreadsheet by 5% for 3 years

If you want to compute the increase in another cell, then in A2 (for
example):

=A1*(1+5%)

If you want to cause the numbers to be increased in existing cells, then put
=1+5% in some cell and copy it. The select the existing cells, right-click
and click Paste Special, click multiply, and click OK. You can now delete
the cell that has =1+5%.

and also some of my colums I need to show a decrease
of 5%.

Similar to the above, but use 1-5% instead of 1+5%.

 

[Gord Dibben]

Enter 1.05 in an unused cell.

Copy that cell.

Select the range to change and Paste Special>Multiply>OK>Esc.

Will add 5% to all cells.

You do the math for a decrease of 5%


Gord Dibben MS Excel MVP