calculate % of difference

[vwhite]

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]

One way:

=A2/A1 - 1

Format the cell as a percentage.

 

[Frank Kabel]

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