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
Bargain Nest Mini (2nd Gen) - Chalk	0	Dec 7, 2020
Nest Guard has hidden microphone	2	Feb 20, 2019
Nest vs Hive?	10	Nov 20, 2020
Nested If / And Statement with Conditional Formatting.	2	Jun 23, 2011
Is there a better way?	7	Nov 2, 2010
Formula nesting with IF statements	2	Feb 12, 2015
Start Do/Loop within conditional statement	4	Jan 13, 2015

Ask a Question