Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Is there any way to bypass the limit of 7 nested functions?
The following formula should return the value in 1 of 12 columns based on the month that is selected from a drop down menu. However, the limitation of 7 nested functions does not allow it to work? Any ideas how go about this a different way? =IF('Report Parameters'!$E$5 = "January", 'Stats and Forecasts - 351'!B48, IF('Report Parameters'!$E$5 = "February", 'Stats and Forecasts - 351'!E48, IF('Report Parameters'!$E$5 = "March", 'Stats and Forecasts - 351'!H48, IF('Report Parameters'!$E$5 = "April", 'Stats and Forecasts - 351'!K48, IF('Report Parameters'!$E$5 = "May", 'Stats and Forecasts - 351'!N48, IF('Report Parameters'!$E$5 = "June", 'Stats and Forecasts - 351'!Q48, IF('Report Parameters'!$E$5 = "July", 'Stats and Forecasts - 351'!T48, IF('Report Parameters'!$E$5 = "August", 'Stats and Forecasts - 351'!W48), IF('Report Parameters'!$E$5 = "September", 'Stats and Forecasts - 351'!Z48, IF('Report Parameters'!$E$5 = "October", 'Stats and Forecasts - 351'!AC48, IF('Report Parameters'!$E$5 = "November", 'Stats and Forecasts - 351'!AF48, IF('Report Parameters'!$E$5 = "December", 'Stats and Forecasts - 351'!AI48))))))))))) Thanks, Bryan |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Nested Functions | Excel Discussion (Misc queries) | |||
More then 7 nested If functions. | Excel Worksheet Functions | |||
NESTED IF FUNCTIONS | Excel Worksheet Functions | |||
Nested IF and MID functions | Excel Worksheet Functions | |||
Nested Functions | Setting up and Configuration of Excel |