Pinterest Pixel

AND Formula in Excel

  What does it do? Checks if all of the conditions are satisfied or not Formula breakdown:... read more

Download Excel Workbook
Bryan
Posted on

Steps To Follow

Overview

AND Formula in Excel | MyExcelOnline AND Formula in Excel | MyExcelOnline

 

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:

AND Formula in Excel | MyExcelOnline

Download excel workbookAND-FORMULA.xlsx

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

=AND(

AND Formula in Excel

 

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,

AND Formula in Excel

[logical2]

What is the second condition?

See also  Change Phone Area Codes with Excel’s REPLACE Formula

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

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

AND Formula in Excel

 

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

AND Formula in Excel

You now have your results!

AND Formula in Excel

 

How to Use the AND Formula in Excel

 

 

AND Formula in Excel | MyExcelOnline

 

If you like this Excel tip, please share it
AND Formula in Excel | MyExcelOnline AND Formula in Excel | MyExcelOnline
AND Formula in Excel | MyExcelOnline
Bryan

Bryan is a best-selling book author of the 101 Excel Series paperback books.

See also  Calculate Pro Rata Share Effortlessly with 2 Easy Methods

Get Video Training

Advance your Microsoft Excel & Office Skills with the MyExcelOnline Academy!

Dramatically Reduce Repetition, Stress, and Overtime!
Exponentially Increase Your Chances of a Promotion, Pay Raise or New Job!

Learn in as little as 5 minutes a day or on your schedule.

Learn More!

Share to...