View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Phillips Bob Phillips is offline
external usenet poster
 
Posts: 1,726
Default 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.