NESTED IF

D.S. · Feb 6, 2004

What is the maximum number of nested IF statements in a worksheet formula?

Frank Kabel · Feb 6, 2004

Hi
7 nested IFs
if you need more the 7 nested comparisons I'd suggest to use VLOOKUP or
similar functions

Frank

D.S. · Feb 7, 2004

Thanks

Frank Kabel said:
Hi
7 nested IFs
if you need more the 7 nested comparisons I'd suggest to use VLOOKUP or
similar functions

Frank

Guest · Feb 25, 2004

Just found out it's 7.

Improving Nested Formula Calculation Efficiency	2	Aug 3, 2011
Nested If / And Statement with Conditional Formatting.	2	Jun 23, 2011
Cell reference using INDIRECT?	2	Jul 6, 2009
Writing a month name from its number	2	Oct 27, 2008
Nested Vlookups	2	Jan 22, 2009
if else statement	3	Aug 15, 2005
Is there a better way?	7	Nov 2, 2010
Nested If Function to be converted into a user-defined customfunction	1	May 18, 2010

Ask a Question