View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Eduardo Eduardo is offline
external usenet poster
 
Posts: 2,276
Default 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!