ExcelBanter - Excel 2000

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Excel 2000 (https://www.excelbanter.com/excel-discussion-misc-queries/232601-excel-2000-a.html)

Keith

Excel 2000

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[_2_]

Excel 2000

=B1/A1-1 and format as percentage.
--
David Biddulph

"keith" wrote in message
...
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?

Keith

Excel 2000

Thanks David, perfect.

Regards Keith

"David Biddulph" wrote:

=B1/A1-1 and format as percentage.
--
David Biddulph

"keith" wrote in message
...
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?

All times are GMT +1. The time now is 10:21 PM.