In this tutorial, we will be working on the nested if function in Excel. We will analyze the If function with 3 conditions in Excel. Here we will see the examples of multiple if functions along with IF functions with AND & OR logic in Excel.
Table of Contents
Multiple IF Statements in Excel (3 IF Functions)
Here, we will use three If functions in one formula to determine the sales status of different products. Let`s say we have some products which are listed as product code in one column. In another column, the monthly sales amount is given. The Product list along with the price is given below.
We will be determining the sales status of these products based on some conditions. The conditions are listed below.
Based on these conditions we will use multiple if functions in column C to determine the sales condition of the products. The formula we will be using is:
In C2, write down the above formula and press enter. You will see the result Excellent will show up in cell C2 as the value 3000 is greater than 2500.
Now, after dragging the formulated cell downwards you will get to see the result for the whole column.
IF functions with AND & OR logic in Excel
We will be working on an interesting example to show you the if function with 3 conditions. Here we will be using the AND & OR function nesting in the IF function.
The experiment will be selecting a bowler based on his performance. Let`s say there are total of 8 bowlers who played a different number of matches. Based on their performances we will be deciding who has good records and who has the bad records. The conditions are given below.
- He has to play at least 7 matches. (This needs to be fulfilled)
- He has to take at least 9 wickets.
- He needs to have an economy rate of less than 6.
Here, The Bowler must meet the 1st condition. After being eligible based on the 1st condition, either the 2nd or 3rd condition needs to be met up. The table is given below.
Here we will be using the below formula.
=IF(AND(B2>=7,OR(C2>9,D2<6)), "Good Record","Bad Record")
First put this formula in cell E2 and drag it down to use this formula for the rest of the cells. You will get to see the below result.
Download The Working File
Whenever you want to evaluate a result based on some conditions you may need to use the multiple if functions or if function with multiple conditions. Hope by reading this article you will get to know how if statement in excel with multiple conditions work.