The IF() function in Excel allows you to evaluate a situation which has two possible outcomes and calculate a different value for each outcome.

However, sometimes you need to work with situations where there are more than two possible outcomes. That's when you need to use multiple, or nested, IF functions.

Syntax:

IF( condition1, value_if_true1, IF( condition2, value_if_true2, value_if_false2 ))

Example:

=IF(J2>80,"A grade",IF(J2>70,"B grade",IF(J2>60,"C grade","D grade")))

[Note: the correct use of brackets in each IF condition]

Mar 05 2014 12:27 PM
However, sometimes you need to work with situations where there are more than two possible outcomes. That's when you need to use multiple, or nested, IF functions.

Syntax:

IF( condition1, value_if_true1, IF( condition2, value_if_true2, value_if_false2 ))

Example:

=IF(J2>80,"A grade",IF(J2>70,"B grade",IF(J2>60,"C grade","D grade")))

[Note: the correct use of brackets in each IF condition]