Thread: HOW TO ADD 7% TO LIST OF PRICES
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Gord Dibben Gord Dibben is offline
external usenet poster
  
Posts: 22,906
Default HOW TO ADD 7% TO LIST OF PRICES
Place 1.07 in an unused cell.

Copy that then select the range to change.

EditPaste SpecialMultiplyOKEsc.

Delete the 1.07


Gord Dibben MS Excel MVP


On Tue, 19 Feb 2008 10:32:03 -0800, SHIGGA
wrote:

I AM TRYING TO FIND OUT HOW TO ADD 7% TO A LIST OF PRICES, IS THERE AN EASY
FORMULA?

Reply With QuoteReply With Quote