K
Knox
I can't seem to figure out why this formula will not work. I have data that
has records with various blanks. I wanted the exponential growth forecast on
just years without blanks. The data looks like this:
2007 2006 2005 2004 2003 2002 2001 etc.
4,260 4,250 4,540 4,560 4,550 3,890 etc.
I wrote an array if statement like this:
{=GROWTH(IF(A2:Z2<>"",A2:Z2,""),IF(A2:Z2<>"",A1:Z1,""),2032)}
Can someone let me know how to fix this? thank you!
has records with various blanks. I wanted the exponential growth forecast on
just years without blanks. The data looks like this:
2007 2006 2005 2004 2003 2002 2001 etc.
4,260 4,250 4,540 4,560 4,550 3,890 etc.
I wrote an array if statement like this:
{=GROWTH(IF(A2:Z2<>"",A2:Z2,""),IF(A2:Z2<>"",A1:Z1,""),2032)}
Can someone let me know how to fix this? thank you!