HOW TO USE MULTIPLE IF IN EXCEL

HOW TO USE MULTIPLE IF IN EXCEL

Using multiple IF statements in Excel

This tutorial will tell you, How to use multiple IF in excel.

The IF() function in Excel allows you to evaluate a logical condition which has two possible results  and calculate a different value for each result. However, sometimes you need to work with conditions where there are more than two possible results. That’s where multiple, or nested, IF functions come in handy. In this tutorial we’ll cover how to use nested IF functions to manipulate a logical condition.

This tutorial assumes you are already familiar with the IF function. If you aren’t, you can learn how to use IF statements here.

Remember that the IF function works by evaluating a logical test – a calculation which can only be TRUE or FALSE.  It  includes a calculation to perform if the logical test is TRUE, and another calculation if it is FALSE.

Nested IF functions work by replacing one or both of the TRUE/FALSE calculations with another IF function.

This formula can be confusing  for first time. Let’s have a look on the syntax & example of multiple/nested IF.

=IF(B2=”APPLE”, “FRUIT”, IF(B2=”TOMATO”, “VEGETABLE”, IF(B2=”SALT”, “SPICES”, “”)))

nested-if

Note :-

If you’ll type TOMATO in B2 then the C2 will change to VEGETABLE , Or if you type SALT in B2 then C2 value will be change to SPICES.

 

Another example of nested IF which calculates the grade of different persons according to score.

nestif

=IF(C4<64,”F”,IF(C4<73,”D”,IF(C4<85,”C”,IF(C4<95,”B”,”A”))))

Here is three nest IF IN this formula which calculate the grade.

So now if you change the score in column C then the grades will be change accordingly.

HOW TO USE VLOOKUP 

HOW TO AND FUNCTION 

 

Leave a Reply

Your email address will not be published. Required fields are marked *