Formula for Growth %
Hi,
you have two ways to do that
let's assume that Jan information is in column B and 2007 information in
cell B2, 2008 in cell B2 and variance in B3
1st option is
=B3/B1
2nd
=(B2/B1)-1
with either formula you get the same results, copy then the formula to your
right
to compare 2009 use the same logic
"Tasha" wrote:
I have been asked to add a Growth % to a spreadsheet someone else created.
I'm not real familiar with any formulas to do this, can someone help me? Below
is how they want it set up:
JAN FEB MAR APR etc....
2007 7 13 10 10
2008 10 6 3 9
Variance 3 -7 -7 -1
Growth %
2009 9 8 12 12
Variance -1 2 9 3
Growth %
I have searched for this on the internet and within this
site, but it seems like growth %'s are very confusing!!!
Any help you can give is appreciated!
|