ExcelBanter - NESTED IF

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - NESTED IF (https://www.excelbanter.com/excel-programming/290576-nested-if.html)

D.S.[_3_]

NESTED IF

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

--
D.S.

Frank Kabel

NESTED IF

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

Frank

D.S. wrote:
What is the maximum number of nested IF statements in a worksheet
formula?

No Name

NESTED IF

Just found out it's 7.
-----Original Message-----
What is the maximum number of nested IF statements in a
worksheet formula?

--
D.S.

.

All times are GMT +1. The time now is 12:27 PM.