The IF() function in Excel allows you to evaluate a situation which has two possible outcomes and calculate a different value for each outcome.
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.
IF( condition1, value_if_true1, IF( condition2, value_if_true2, value_if_false2 ))
=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]