How to write the Excel AND function (with examples)

Learn with ease how to write AND function in Excel by watching our short video and our various examples. Use AND with multiple cells or/and conditions and with text like a pro!

Learn how to write AND function in Excel like a pro with Ted Jordan: discover the AND function formula, how to use it with multiple criteria or text and when to use it.

Read our tutorial to understand how the Excel AND function works in various situations.

Ready to increase your Excel knowledge?

Let’s go!

The Excel AND function determines if all conditions included in its syntax are met: if so, TRUE will appear as the result of the AND formula. If not all conditions are met, FALSE will be displayed.

The Excel AND function formula is =AND(logical1, [logical2], …) with logical1 being the only required argument.

logical1 — this argument represents the 1st condition you want to test with the AND formula.
logical2… — additional conditions to test with the AND formula.

Excel AND function – Tips

– You can add up to 255 conditions in the AND function in Excel.
Empty cells will be ignored by the system.
– For conditions with text elements, use quotation marks “” in logical values or the system will skip these cells.

We recommend to use the Excel AND function when you want to test multiple conditions at the same time.

To display specific values for TRUE or FALSE result, you can combine AND with IF for example.

Click here to learn how to combine AND and IF functions.

Use the AND formula in Excel when you want to check if some conditions are all met. You can of course use AND for 1 condition if you wish to, or use this handy function with IF to display specific results.

Click here to know more about the IF function in Excel.

You can test one criteria (condition) in Excel for multiple cells easily with the AND function.

For example, =AND(B22:E22>0) will check if cells B22, C22, D22 and E22 contain numbers higher than 0. If so, TRUE will be the result and if not, FALSE will appear.

In this example, AND helps us check if our customers ordered with us each quarter: if they did, we will send them a promo code to thank them.

Learn how we highlighted TRUE results automatically with Conditional Formatting.

You’ll see it’s easy to use AND function in Excel for 3 or more conditions.

First, click the cell where you want the result to appear.

Then, enter =AND(condition1, condition2, condition3) and press Enter.

In our example, we want to check if some clients increased the number of orders each quarter. If so, we will send them a promo code to thank them!

condition1 is C>B
condition2 is D>C
condition3 is E>D

If all these conditions are met, the result will be TRUE. If not, FALSE will appear.

In this example, Tanguy and Andy ordered more with us quarter after quarter.
Thanks to Conditional Formatting, it’s easy to see TRUE results!

Use AND with text elements in Excel by writing text within quotation marks “”.

For example, =AND(B22:E22>0,A22=”Ted”) will be TRUE if cells B22 to E22 contain numbers higher than 0 and cell A22 contains Ted or ted.

To help you understand, if all cells are ticked with a green sign, the result is TRUE. If not, the result is FALSE.

Now, you know how to write the Excel AND function for one or multiple conditions, for one or multiple cells; you also learned how to write AND function with text for the system to check conditions.

Don’t waste your Excel knowledge: get certified!

Join our MS Excel Online Course: learn at your own pace, receive support from Excel experts by email, receive a free Spreadsheet Cheat Sheet and much more!

Advertising
Analytics

Categories

AllAdvertisingFormatsPlatformsKPI'sAd News
What is Programmatic Advertising?

What is Programmatic Advertising?

Understand what programmatic advertising is and how it works to increase your ROI and become a programmatic specialist.

Read More

Best DSPs for Programmatic Advertising

Ted Jordan shares his list of best DSPs for Programmatic Advertising so you don’t have to lose time searching the internet to find the right Demand-Side Platform for your campaigns.

Read More
Programmatic Advertising: What is a DSP?

What are DSPs?

A DSP is a great tool to use but what does DSP stand for in marketing? What are some Demand-Side Platforms examples? Today, we answer your questions!

Read More

What is O&O Advertising?

Discover one more important jargon term used in Programmatic Advertising: O&O advertising. Get familiar with O&O formats and advantages.

Read More
Programmatic Advertising: What is a SSP?

Supply-Side Platforms (SSPs) Explained

SSPs basics in advertising: learn what Supply-Side Platforms are used for and who use them. Get familiar with more programmatic advertising technical terms.

Read More
Programmatic: Pixels in Advertising 101

Advertising pixels: types, pros and best practices

Learn the basics of Programmatic Advertising with Ted Jordan! Today, we explain what a pixel is in advertising with simple words and expertise. Ready to learn?

Read More

Categories

AllFunctionsToolsShortcut Keys

How to change shapes in Excel column charts

Learn how to easily change the columns shape in your Excel charts so your colleagues and customers will remember your impacting graphs.

Read More

How to use the LEFT, RIGHT and MID functions

Learn how to extract text in Excel with the LEFT, RIGHT and MID functions. Plenty of examples to learn from and functions are explained with simple words. If you start...

Read More
Split Semicolon Separated Value in Excel

How to split semicolon separated values in Excel

Split semicolon separated values in Excel into columns and rows, or convert columns to semicolon separated values, like an Excel Master!

Read More

Excel IF statement: how to use it for 3 conditions

Learn how to use the Excel IF statement with multiple conditions and combine it with OR and/or AND functions!

Read More
Navigating with Tab, Enter, and Shift Key on Excel.

How to move between cells when arrow keys are not working (Excel)

Learn how to move between Excel cells without using your mouse or arrow keys. Discover more shortcuts and tricks below!

Read More

How to use the IFERROR function (Excel + Google Sheets)

Discover how to use IFERROR in Excel or in Google Sheets in 4 easy steps! No more errors on your documents or dashboards with IFERROR.

Read More