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

[Guest]

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.

 

[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

 

[Guest]

THANK YOU! I don't know why I could not see that myself! Long day!! lol