How to use the IF function with the AND function in Excel

Aug 13, 2023

Learn how to use the IF function with the AND function in Microsoft Excel. This tutorial demonstrates how to use the 2 Excel functions together with an easy to follow example.

IF Function with AND Function (and sample data):
https://www.techonthenet.com/excel/fo…

IF Function:
https://www.techonthenet.com/excel/fo…

AND Function:
https://www.techonthenet.com/excel/fo…

Excel Tutorials:
https://www.techonthenet.com/excel/in…

Don’t forget to subscribe to our channel for more great Excel tutorials!

Visit us at: https://www.techonthenet.com
or follow us on:

Facebook: https://www.facebook.com/techonthenetcom
Twitter: https://twitter.com/tech_on_the_net
Pinterest: https://www.pinterest.com/techonthene…

Content

0 -> You can combine the IF function with the AND function to test for multiple conditions

5.34 -> When using the AND function, all conditions within the AND function

9.42 -> must be TRUE for the condition to be met

12.18 -> To illustrate how the IF function works with the AND function, let's look at an example

17.1 -> Here we have a table of data that consists of 2 columns - "Name" and "Score"

22.04 -> Let's use the two functions to return a value of "MVP"

25.64 -> if the name is "Anderson" and the score is greater than 80

29.04 -> To get started, let's begin by entering the IF command

32.82 -> As you can see, our formula can take 3 parameters

36.16 -> In the first parameter, we will need to enter the condition to test for

40.1 -> Since the IF function will only accept one condition and we have two conditions we would like to test for

46.46 -> we will need to utilize the AND function

49.18 -> The AND function requires the minimum of one condition and can take up to 30 conditions, in total

55.14 -> It performs the Logical "AND operation" evaluating to TRUE

59.38 -> only if all of the conditions provided evaluate to TRUE

63.62 -> So let's enter the AND function with our conditions now

68.02 -> In our example, we want to test to see if the value in cell A2 is equal to "Anderson"

74.28 -> and the value in cell B2 is greater than 80

78.18 -> The second parameter we will need to enter is the value to return

82.52 -> if all conditions in the AND function are TRUE

85.72 -> In our example, we will enter the value "MVP"

89.06 -> This means that if the Name is "Anderson" and the score is greater than 80, the formula will return "MVP"

96.06 -> We will enter "Regular" as the third parameter

99.6 -> This is the value that will be returned if any of the conditions in the AND function evaluate to FALSE

105.54 -> Now let's complete the command and see what is returned

109.34 -> You should see the value "MVP" appear in cell D2

112.98 -> Since the value in cell A2 is "Anderson" and the value in cell B2 is greater than 80

119.1 -> both conditions are true and the value "MVP" is returned

123.16 -> Now, let's copy our formula into cells D3 to D4

129.58 -> Since the two conditions are not met in rows 3 and 4, the formula returns the value "Regular" as the result

136.74 -> This completes our example of how to use the IF function with the AND function in Excel

142.42 -> If you would like to see more examples

144.68 -> or would like to download the sample data we used for this tutorial

148.04 -> please visit our website at TechOnTheNet.com

152.21 -> If you found our tutorial helpful, please leave a like on this video

156.16 -> and don't forget to subscribe to our YouTube channel for more great Excel tutorials

Source: https://www.youtube.com/watch?v=8q_L2Hqp_TU