ExcelBanter - calculate percent increase

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

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

- - calculate percent increase (https://www.excelbanter.com/excel-discussion-misc-queries/929-calculate-percent-increase.html)

vlro

calculate percent increase

I am trying to calculate the percent increase in pricing.
Say I have $10.35 in cell A5 and 11.32 in cell A6. How can I calculate the
percent increase in cell A&. I know this has to be simple, but I seem to
have trouble getting it to work.

Thanks

Jason Morin

=A6/A5-1

Format the cell as %.

HTH
Jason
Atlanta, GA

-----Original Message-----
I am trying to calculate the percent increase in
pricing.
Say I have $10.35 in cell A5 and 11.32 in cell A6. How
can I calculate the
percent increase in cell A&. I know this has to be
simple, but I seem to
have trouble getting it to work.

Thanks
.

All times are GMT +1. The time now is 09:16 PM.