View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
David Biddulph David Biddulph is offline
external usenet poster
 
Posts: 620
Default 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.