Percentage increase of one cell to another in Excel?

H

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?
 
A

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
 
S

Shane Devenshire

Hi,

Or an equivalent way to think about this would be

=D1/C1-1

where D1 is 99 and C1 is 89
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Percentage Increase 11
Excel Formula question 0
MS Project. Real progress of the project, % complete 1
Doughnut Chart linked with the slicer in the pivot table 0
percentage in brackets 2
Creating an Excel Freight Calculator 2
Distribution of capital contribution 4
Calculating percentage growth rate from a cumulative figure 4

Top