Excel 2000

[keith]

A simple issue but I can't work it out, can anyone help.
If A1 shows last years sales and B1 shows this years sales, how can I get C1
to show the percentage increase/decrease in sales?

 

[David Biddulph]

=B1/A1-1 and format as percentage.

 

[keith]

Thanks David, perfect.

Regards Keith

=B1/A1-1 and format as percentage.