NESTED IF

[D.S.]

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

 

[Frank Kabel]

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

Frank

 

[D.S.]

Thanks

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

Frank

 

[Guest]

Just found out it's 7.