View Single Post
 
Old 04-14-2022, 02:02 AM
ArviLaanemets ArviLaanemets is offline Windows 8 Office 2016
Expert
 
Join Date: May 2017
Posts: 932
ArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant future
Default

Quote:
Originally Posted by Pecoflyer View Post
As a matter of fact modern versions of XL ( starting at 2007 I think) will accept 64 levels of nested IF
After this was pointed out, I did find this information from MS Help (had to go to another page using a link, and reading through text there).

In past, there was the limit for number of nested IF's declared at end of MS Help for IF function. Not anymore! (Btw, I searched for this limit earlier, and couldn't find it then.)
Reply With Quote