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:
=(D1B1)/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:
=(D1B1)/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%?
=(D1B1)/B1 in E1 will give you the percent change from the initial price.
=(D1B1)/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 © 19982004 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.