Excel And Function

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

Description

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.

Syntax

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

Example

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
Statistic Pass 4 Out of 5 Rounds 1

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
Calculate Weekly Average 10

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
check value is between two numbers2

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
ignore blank zero cells in 7

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
return value if date fall two dates1

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 ...

Check If Multiple Cells are Equal In Excel
check if multiple cells equal2

This post will guide you how to check if the values of multiple cells are equal with a formula in Excel. How do I verify that multiple cellsare the same in Excel. How to compare three or more cells in ...

Find Duplicate Values in Two Columns
find duplicate cells in two columns111

This tutorial will show you how to find duplicate values in two given columns in Excel. Or How to compare two columns and find duplicate entries in Microsoft Excel worksheet. And you will learn two methods to compare columns so ...

Check if Cell Contains Certain Values but do not Contain Others Values
contains certain values but do not contain1

In the previous post, we only talked that how to check a cell if contains one of several values from a range in excel. And this post explains that how to check a cell if it contains certain values or ...

Excel IF Function With Numbers
Excel IF Function Examples For Numbers3

Normally, If you want to write an IF formula for numbers in combining with the  logical operators in excel, such as: greater than, less than, greater than or equal to, less than or equal to, equal to, not equal to.etc. ...

Excel IF formula with NOT logical function
Excel formula using IF NOT function3

This post will guide you how to use excel if formula with NOT logical function in Microsoft excel. NOT Logical Function The syntax of NOT logical function is as follow: =NOT(logical_value) The NOT logical function will return the reversed logical ...

Sidebar