| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Percent of Growth Formula
My question is simple... How do you create a formula that would show the rate
of growth from one value to another. For examle: 2005 Clients: 100 2006 Clients: 200 Clients grew from 100 to 200 which represents a 100% growth rate. How would this formula be created? Thank you. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Percent of Growth Formula
=(A2-A1)/A1
and formatted as a percentage -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Ana Maria" <Ana wrote in message ... My question is simple... How do you create a formula that would show the rate of growth from one value to another. For examle: 2005 Clients: 100 2006 Clients: 200 Clients grew from 100 to 200 which represents a 100% growth rate. How would this formula be created? Thank you. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Percent of Growth Formula
Try =(200-100)/100 changing the numbers for the cell references I.e if 100 is
in cell A1 and 200 in cell A2 your formula would be (a2-a1)/a1 and format the cell to % John "Ana Maria" wrote: My question is simple... How do you create a formula that would show the rate of growth from one value to another. For examle: 2005 Clients: 100 2006 Clients: 200 Clients grew from 100 to 200 which represents a 100% growth rate. How would this formula be created? Thank you. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Percent of Growth Formula
If your data values are in cells B1 and B2 respectively, you want
=(B2/B1)-1, formated as percentage. -- David Biddulph "Ana Maria" <Ana wrote in message ... My question is simple... How do you create a formula that would show the rate of growth from one value to another. For examle: 2005 Clients: 100 2006 Clients: 200 Clients grew from 100 to 200 which represents a 100% growth rate. How would this formula be created? Thank you. |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Percent of Growth Formula
DAvid - your formula is the one I use, but with the precedence of operators
you can dispense with the parens: =B2/B1-1 "David Biddulph" wrote: If your data values are in cells B1 and B2 respectively, you want =(B2/B1)-1, formated as percentage. -- David Biddulph "Ana Maria" <Ana wrote in message ... My question is simple... How do you create a formula that would show the rate of growth from one value to another. For examle: 2005 Clients: 100 2006 Clients: 200 Clients grew from 100 to 200 which represents a 100% growth rate. How would this formula be created? Thank you. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| need formula for percent off of column | New Users to Excel | |||
| Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
| trying to make a formula for percent if greater than a value | Excel Discussion (Misc queries) | |||
| Percent Variance Formula | Excel Discussion (Misc queries) | |||
| Need Formula or Function to calculate Margin (reverse of Percent a | Excel Worksheet Functions | |||
Linear Mode
