Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Long IF Statement | Excel Discussion (Misc queries) | |||
more than 3 conditions in conditional formatting - possible? | Excel Discussion (Misc queries) | |||
Date & Time | New Users to Excel | |||
Automatically up date time in a cell | Excel Discussion (Misc queries) | |||
clock | Excel Worksheet Functions |