Thread: Excel VLOOKUP - Return cells that are not blank from range of specified cells
View Single Post
 
Old 05-09-2022, 11:59 AM
spillerbd spillerbd is offline Windows 10 Office 2013
Competent Performer
  
Join Date: Jan 2016
Posts: 130
spillerbd is on a distinguished road
Default
Quote:
Originally Posted by ArviLaanemets View Post
The first formula has 7 nested IF's, what is a max number of nesting allowed!
Nested ifs are limited to 7 in the 32-bit version. Using the 64-bit version allows 64 levels of nesting.
64-bit is the preference for Excel and has recently become accepted. I have been 64-bit since, oh I forget when, 2010 I think.
Reply With Quote