← Guides

Nested IF and IFS in Excel

Nested IF

=IF(A2>=90,"A",IF(A2>=80,"B",IF(A2>=70,"C","D")))

IFS (clearer)

=IFS(A2>=90,"A",A2>=80,"B",A2>=70,"C",TRUE,"D")

Better: lookup table

Store thresholds in a table and use XLOOKUP / approximate MATCH — easier to audit than deep nesting.

#NAME? if IFS missing · Directory