Percentage increase of one cell to another in Excel?

[Holly]

I am trying to find the percentage difference from one cell to another. Cell
C1 is $89 and cell D1 is $99. What is the formula to find the percentage
increase?

 

[Ashish Mathur]

Hi,

In cell E1, type the following formula in the formula bar

=(D1-C1)/C1. Ensure that the cell is formatted as %.

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

 

[Gord Dibben]

=(D1-C1)/C1

returns .11236 or 11.236% increase.


Gord Dibben MS Excel MVP

 

[Shane Devenshire]

Hi,

Or an equivalent way to think about this would be

=D1/C1-1

where D1 is 99 and C1 is 89

 

[Gord Dibben]

Much more simple.

Thanks Shane


Gord