Thread: Finding % sum instead of $ sum (as in % change)
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Roger Govier
 
Posts: n/a
Default Finding % sum instead of $ sum (as in % change)
Hi

Assuming Year1 figures in column A, and Year 2 figures in column B, in
C1 enter
=(B1-A1)/A1
Format B1 as Percentage

--
Regards

Roger Govier


"MissBonnie" wrote in message
...
I am entering annual sales figures, comparing year to year, and want to
get
the percentage change instead of the $ change. How do I do this?
Thanks.


Reply With QuoteReply With Quote