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

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

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Finding % sum instead of $ sum (as in % change) (https://www.excelbanter.com/excel-worksheet-functions/90341-finding-%25-sum-instead-%24-sum-%25-change.html)

MissBonnie

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

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

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

Hi

Assuming Year1 figures in column A, and Year 2 figures in column B, in
C1 enter
=(B1-A1)/A1
Format B1 as Percentage

--
Regards

Roger Govier

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

MissBonnie

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

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

"Roger Govier" wrote:

Hi

Assuming Year1 figures in column A, and Year 2 figures in column B, in
C1 enter
=(B1-A1)/A1
Format B1 as Percentage

--
Regards

Roger Govier

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

All times are GMT +1. The time now is 06:25 PM.