AND Formula in Excel

 

What does it do?

Checks if all of the conditions are satisfied or not

Formula breakdown:

=AND(logical1, [logical2], …)

What it means:

=AND(first condition, [additional conditions], …)

---

Have a couple of conditions that you need to check for and ensure they are met? The AND Formula of Excel enforces this and will return TRUE if all of your required conditions are met!

Let us give this a try in our examples below, we want to check if the date is in the month of January and the sales amount is greater than $1000.

I explain how you can do this below:

STEP 1: We need to enter the AND function in a blank cell:

=AND(

 

STEP 2: The AND arguments:

logical1

What is the first condition?

Let us create the condition to get the month of the date and check if it is January:

=AND(MONTH(C9)=1,

[logical2]

What is the second condition?

Let us create the condition to check if sales is greater than 1000:

=AND(MONTH(C9)=1, D9 > 1000)

 

Apply the same formula to the rest of the cells by dragging the lower right corner downwards.

You now have your results!

 

How to Use the AND Formula in Excel