I'm not familiar with this function, but I wonder if part of your problem is
that you have 2032 instead of an array of the same length as A2:Z2.
--
HTH,
Barb Reinhardt



"Knox" wrote:

I tried using the following formula to find exponential growth. Some of the
data has blanks so I want to ignore those cells. This doesn't seem to work,
should I write a macro? thanx!

{=GROWTH(IF(A2:Z2<"",A2:Z2,""),IF(A2:Z2<"",A1:Z1 ,""),2032)}

2007 2006 2005 2004 2003 2002 2001 etc
4,260 4,250 4,540 4,560 4,550 3,890 etc
4,910 3,450 etc
5,930 7,160 6,010 5,160 4,150 4,520 etc