Thread
:
Excel VLOOKUP - Return cells that are not blank from range of specified cells
View Single Post
04-14-2022, 12:17 AM
Pecoflyer
Windows 7 64bit
Office 2010
Expert
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,779
Quote:
Originally Posted by
ArviLaanemets
The first formula has 7 nested IF's, what is a max number of nesting allowed!
As a matter of fact modern versions of XL ( starting at 2007 I think) will accept 64 levels of nested IF
__________________
Did you know you can thank someone who helped you
? Click on the tiny scale in the right upper hand corner of your helper's post
Pecoflyer
View Public Profile
Find all posts by Pecoflyer