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)
