Excel And Function

This post will guide you how to use Excel AND function with syntax and examples in Microsoft excel.


The Excel AND function returns TRUE if all of arguments are TRUE, and it returns FALSE if any of arguments are FALSE.

The AND function is a build-in function in Microsoft Excel and it is categorized as a Logical Function.

The AND function is available in Excel 2016, Excel 2013, Excel 2010, Excel 2007, Excel 2003, Excel XP, Excel 2000, Excel 2011 for Mac.


The syntax of the AND function is as below:

= AND (condition1,[condition2],…)

Where the AND function arguments are:
Condition1 -This is a required argument. The first arguments to test if it is true.
Condition2 – Optional


The below examples will show you how to use Excel AND Function to test whether all of conditions are TRUE.

#1 To Test if B1 is greater than 10 AND less than 20, if so, returns TRUE value, just using the following excel formula: =AND(B1>10, B1<20)

excel and function example1

More Excel AND Function Examples

  • Conditional Formatting date with red Amber or Green
    How to highlight the date with red if the cell dates is past now(). How to highlight the date with amber if the cell date is past now but within the next 6 months from now(). How to highlight the date with green if the cell date is more than 6 months from now…
  • Check If Multiple Cells are Equal In Excel
    Assuming that you have a list of data in range A1:C1, and you want to compare if these cells are equal, if so, then return True, otherwise, return False. You need to create an Excel array formula based on the AND function and the EXACT function…
Related Posts

How to Statistic Pass 4 Out of 5 Rounds in a Competition by Excel Functions

Suppose you are counting the numbers of participants who are the winners in a competition. And the passing line is provided as pass 4 out of 5 rounds of games. You need to know if participant pass the game or ...

How to Calculate Weekly Average by Formula in Excel

In our daily life we often create tables for recording the money we spend for lunch or dinner or something else per date. This can help us know the total cost or average cost per date or other unit clearly ...

How to Check If value Is between Two Numbers in Excel

This post will guide you how to check if a cell value is between two numbers in Excel. How do I build an IF statement that test if a cell value is between two given values in formula in Excel. ...

Ignoring Blank or Zero Cells with Conditional formatting

This post will guide you how to make conditional formatting ignore blank cells or zero cell in Excel. How do I force blank cells or zero cells to be ignored in conditional formatting in Excel. How to ignore blank cells ...

Returning Value if the Dates Fall between Two Dates

This post will guide you how to calculate value between two dates if the dates falls those two dates in Excel. How do return a value if the dates fall between two given dates in excel. How to use a ...