Skip to content
xlsoffice. All Rights Reserved
  • Home
  • Excel For Beginners
  • Excel Intermediate
  • Advanced Excel For Experts

Lookup and Reference Examples

  • How to get first column number in range in Excel
  • To count total rows in a range in Excel
  • How to get relative column numbers in a range in Excel
  • Get nth match with INDEX / MATCH in Excel
  • How to get last column number in range in Excel

Data Analysis Examples

  • Working With Tables in Excel
  • Number and Text Filters Examples in Excel
  • Conditional Formatting Rules in Excel
  • Use Data Form to input, edit and delete records in Excel
  • Managing Conditional Formatting Rules in Excel

Data Validation Examples

  • Excel Data validation date in specific year
  • Excel Data validation allow weekday only
  • Excel Data validation don’t exceed total
  • Excel Data validation number multiple 100
  • Excel Data validation require unique number

How to use Excel AND Function

by

This Excel tutorial explains how to use the AND function with syntax and examples.

Excel AND Function Description

Microsoft Excel AND function tests a number of supplied conditions and returns TRUE if all conditions are TRUE. It returns FALSE if any of the conditions are FALSE.

That is;

  • TRUE if ALL of the conditions evaluate to TRUE
Worked Example:   Highlight dates between in Excel

or

  • FALSE otherwise (i.e. if ANY of the conditions evaluate to FALSE).

Excel And Function Examples

The following spreadsheet shows three examples of the Excel And function:

Explanation:  Based on the example above, the AND function returns;

  • the function in cell C1 evaluates to TRUE, as BOTH of the supplied conditions are TRUE;
  • the function in cell C2 evaluates to FALSE, as the third condition, B2>12, is FALSE;
  • the function in cell C3 evaluates to FALSE, as ALL of the supplied conditions are FALSE.
Worked Example:   Excel Data validation only dates between

Syntax

AND( logical_test1, [logical_test2], … )

Arguments

where the logical_test arguments are one or more conditions that evaluate to either TRUE or FALSE.

Notes:

  • In current versions of Excel (Excel 2007 and later), you can enter up to 255 logical_test arguments to the Excel And function. However, in Excel 2003, the function can only handle up to 30 arguments.
  • If the logical_test arguments evaluate to numbers, instead of logical values, the value zero is treated as FALSE and all non-zero values are treated as TRUE.
Worked Example:   Find duplicate values in two columns in Excel

Post navigation

Previous Post:

How to use Excel NOT Function

Next Post:

How to use Excel OR Function

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Learn Basic Excel

Ribbon
Workbook
Worksheets
Format Cells
Find & Select
Sort & Filter
Templates
Print
Share
Protect
Keyboard Shortcuts

Categories

  • Charts
  • Data Analysis
  • Data Validation
  • Excel Functions
    • Cube Functions
    • Database Functions
    • Date and Time Functions
    • Engineering Functions
    • Financial Functions
    • Information Functions
    • Logical Functions
    • Lookup and Reference Functions
    • Math and Trig Functions
    • Statistical Functions
    • Text Functions
    • Web Functions
  • Excel VBA
  • Excel Video Tutorials
  • Formatting
  • Grouping
  • Others
  • How to count keywords in a range of cell
  • Join Text Strings Using Concatenate or ‘& Operator’ in Excel
  • FIXED function: Description, Usage, Syntax, Examples and Explanation
  • How to add a line break with a formula while joining text strings in Excel
  • Find most frequent text within a range with criteria in Excel
  • Convert decimal minutes to Excel time
  • Generate series of dates by weekends in Excel
  • How to calculate workdays per month in Excel
  • How to calculate most recent day of week in Excel
  • Get work hours between dates and times in Excel
  • Calculate payment periods for loan in Excel
  • Calculate payment for a loan in Excel
  • DISC function: Description, Usage, Syntax, Examples and Explanation
  • Compound Annual Growth Rate CAGR formula examples in Excel
  • XNPV function: Description, Usage, Syntax, Examples and Explanation
Acronyms, Abbreviations, Initialism & What They Stand For
© 2022 xlsoffice . All Right Reserved. | Teal Smiles