Archive of Mr Excel Message Board


Back to Forms in Excel VBA archive index
Back to archive home

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)


Check out our Excel Resources

Re: Percentage of increase between 2 numbers - URGENT

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


Re: Percentage of increase between 2 numbers - URGENT

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


Typo

Posted by Scott on January 18, 2002 12:38 PM
Problems witht he keyboard today.

28x2 is 56 of course.


Re: Percentage of increase between 2 numbers - URGENT

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


Re: Percentage of increase between 2 numbers - URGENT

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.


as below and format as % (NT)

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

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.