Nested IF



0
ho to use multiple if in one cell ..explain

1 Answer(s)


0

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]

Your Answer

Click on this code-snippet-icon icon to add code snippet.

Upload Files (Maximum image file size - 1.5 MB, other file size - 10 MB, total size - not more than 50 MB)

Email
Password