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.

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.

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.

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.

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.