ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Array If (https://www.excelbanter.com/excel-discussion-misc-queries/163532-array-if.html)

Knox

Array If
 
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!



All times are GMT +1. The time now is 09:46 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com