Thread: Increasing and decreasing numbers by 5% ....also showing a loss
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
  
Posts: 22,906
Default Increasing and decreasing numbers by 5% ....also showing a loss
Enter 1.05 in an unused cell.

Copy that cell.

Select the range to change and Paste SpecialMultiplyOKEsc.

Will add 5% to all cells.

You do the math for a decrease of 5%


Gord Dibben MS Excel MVP

On Sat, 11 Apr 2009 15:28:01 -0700, Karen
wrote:

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!

Reply With QuoteReply With Quote