Aug 23 2017
09:15 AM
- last edited on
Jul 25 2018
09:57 AM
by
TechCommunityAP
Aug 23 2017
09:15 AM
- last edited on
Jul 25 2018
09:57 AM
by
TechCommunityAP
Hi,
According to the Excel Help tutorial, you can nest up to 64 IF functions. But I am only permitted to nest 8. Excel returns this error message as soon as I press enter: The specified formula cannot be entered because it uses more levels of nesting than are allowed in the current file format.
My formula:
=IF(G22<=10,"60",IF(G22>=11,"75",IF(G22>=21,"90",IF(G22>=31,"105",IF(G22>=41,"120",IF(G22>=51,135",IF(G22>=61,"150",IF(G22>=71,"165",IF(G22>=81,"180",IF(G22>=91,"195",IF(G22>=101,"210",IF(G22>=111,"225",IF(G22>=121,"240",IF(G22>=131,"255",IF(G22>=141,"270",IF(G22>=151,"285",IF(G22>=161,"300",IF(G22>=171,"315",IF(G22>=181,"330","")))))))
Basically, if the test is not true, there should be an incremental increase of 15 each time.
What am I doing wrong that prevents nesting beyond eight nests?
Aug 23 2017 11:40 PM
SolutionAug 24 2017 05:57 AM
Thank you so much. I was not familiar with the VLOOKUP function but it works. Thanks!
Aug 25 2017 04:22 AM
Apr 13 2022 02:52 PM
Aug 23 2017 11:40 PM
Solution