1. Microsoft Excel What If Function
2. Excel If Functions For Dates

The array result from the IF function is delivered directly to the MAX function, which returns the maximum value in the array. With MAXIFS In Excel O365 and Excel 2019, the new MAXIFS function can find the maximum value with one or more criteria without the need for an array formula. The information in this article applies to Excel 2019, Excel 2016, Excel 2013, Excel 2010, Excel 2007, and Excel for Mac. About the MEDIAN and IF Functions The job of each part of the formula is.

• Use function key shortcuts. Excel for Mac uses the function keys for common commands, including Copy and Paste. For quick access to these shortcuts, you can change your Apple system preferences so you don't have to press the FN key every time you use a function key shortcut.
• Excel for Office 365, Excel 2019, Excel 2016, Excel 2013, Excel 2011 for Mac, Excel 2010, Excel 2007, Excel 2003, Excel XP, Excel 2000 Type of Function VBA function (VBA).

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.

Insert formulas and functions in Numbers on Mac. You can create formula or function cells that automatically perform calculations using the data in any cells you select. For example, you can compare values in two cells, calculate the sum or product of cells, and so on. The result of a formula or function appears in the cell where you entered it.

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: =IF(B2>=2500,'Excellent',IF(B2>=2000,'Good',IF(B2>1000,'Average','Poor ')))

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

Conclusion

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.

Microsoft Excel What If Function

Excel If Functions For Dates