Nested IF

ho to use multiple if in one cell ..explain

1 Answer(s)


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.

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]