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.