Percent of Growth Formula

[Guest]

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.

 

[Bob Phillips]

=(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)

 

[Guest]

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

 

[David Biddulph]

If your data values are in cells B1 and B2 respectively, you want
=(B2/B1)-1, formated as percentage.

 

[Guest]

DAvid - your formula is the one I use, but with the precedence of operators
you can dispense with the parens:

=B2/B1-1