Finding % sum instead of $ sum (as in % change)

M

MissBonnie

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.
 
R

Roger Govier

Hi

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