![]() |
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