MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Percentage of increase between 2 numbers - URGENT


Posted by Kevin on January 18, 2002 11:56 AM

If I have a dollar figure in column B and another higher dollar figure in column D, how do I get the result in column E as an amount of percentage increase.

(IE 28.00 in column B and 59.00 in column D should reflect a 51% increase in column E)


Posted by Scott on January 18, 2002 12:37 PM

Your example 28 to 59 is actually a 110.7% increase (28 x 2 would equal 54 which is 100 percent). Anyway, here are some formulas to start:

=(D1-B1)/B1 "This gives you a percent increase from B.

=B1/D1 "This gives you the percent of B to D

Posted by Scott on January 18, 2002 12:37 PM

Posted by Scott on January 18, 2002 12:38 PM

Typo

Problems witht he keyboard today.

28x2 is 56 of course.

Posted by val on January 18, 2002 12:40 PM

Assuming your values start in row 2, enter this formula in cell E2:

=(D1-B1)/B1

use the fill down tool as necessary.

If I'm reading your example correctly, it actually depicts a 110% increase, not 51%...

Val

Posted by Steve Hartman on January 18, 2002 12:44 PM

Well, first of all isn't a move from $28 to $59 an increase of 111%?

=(D1-B1)/B1 in E1 will give you the percent change from the initial price.

=(D1-B1)/D1 in E1 will give you the change as a pertenage of the final price.

Posted by Chris D on January 18, 2002 3:04 PM

as below and format as % (NT)