Thread
:
Percent of Growth Formula
View Single Post
#
2
Posted to microsoft.public.excel.worksheet.functions
Bob Phillips
external usenet poster
Posts: 1,726
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.
Reply With Quote
Bob Phillips
View Public Profile
Find all posts by Bob Phillips