View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Bryan Potter Bryan Potter is offline
external usenet poster
 
Posts: 11
Default Nested Functions

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