Thread
:
Percent of Growth Formula
View Single Post
#
4
Posted to microsoft.public.excel.worksheet.functions
David Biddulph
external usenet poster
Posts: 620
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.
Reply With Quote
David Biddulph
View Public Profile
Find all posts by David Biddulph