IF statement too long
Correction:
You can combine:
=IF(ISBLANK($F$5)," ",IF(F6<2," ",........
Into:
=IF(AND(F5="",F6<2),"",................
Make that:
=IF(OR(F5="",F6<2),"",................
Biff
"Biff" wrote in message
...
Hi!
You can combine:
=IF(ISBLANK($F$5)," ",IF(F6<2," ",........
Into:
=IF(AND(F5="",F6<2),"",................
That'll allow you to add 1 more nested IF for 2006.
However, your best bet would be to create a table and do a lookup.
Biff
"KSH" wrote in message
...
I have a cell with the following:
=IF(ISBLANK($F$5)," ",IF(F6<2," ",IF(F5=2000,'(4)Commercial
Savings'!D16,IF(F5=2001,'(4)Commercial
Savings'!D21,IF(F5=2002,'(4)Commercial
Savings'!D26,IF($F$5=2003,'(4)Commercial
Savings'!D31,IF($F$5=2004,'(4)Commercial
Savings'!D36,IF($F$5=2005,'(4)Commercial Savings'!D41))))))))
I am trying to add another if for the year 2006, but I get an error, I
think
there is a limit to the number of IF's if so, how do I program this?
Thanks,
--
KSH
|