calculate % of difference

vwhite · May 26, 2004

I'm not sure how to get an accurate percentage of
difference from product sold last year(1A) to this year
(2A). Can anyone help? Thanks.

JE McGimpsey · May 26, 2004

One way:

=A2/A1 - 1

Format the cell as a percentage.

Frank Kabel · May 26, 2004

Hi
try
=(A2-A1)/A1
and format this as percentage