Percentage increase of one cell to another in Excel?
 

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?
--
Holly N

Percentage increase of one cell to another in Excel?
 

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

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

Percentage increase of one cell to another in Excel?
 

=(D1-C1)/C1

returns .11236 or 11.236% increase.


Gord Dibben MS Excel MVP

On Wed, 3 Dec 2008 14:55:01 -0800, Holly
wrote:

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?

Percentage increase of one cell to another in Excel?
 

Hi,

Or an equivalent way to think about this would be

=D1/C1-1

where D1 is 99 and C1 is 89

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"Holly" wrote:

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?
--
Holly N

Percentage increase of one cell to another in Excel?
 

Much more simple.

Thanks Shane


Gord

On Thu, 4 Dec 2008 01:11:01 -0800, Shane Devenshire
wrote:

Hi,

Or an equivalent way to think about this would be

=D1/C1-1

where D1 is 99 and C1 is 89