Thread: Excel VLOOKUP - Return cells that are not blank from range of specified cells
View Single Post
 
Old 04-14-2022, 02:02 AM
ArviLaanemets ArviLaanemets is offline Windows 8 Office 2016
Expert
  
Join Date: May 2017
Posts: 873
ArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud of
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