Quick Answer

AND Function

AND checks if ALL conditions are TRUE.

Syntax

AND

(logical1, [logical2], ...)

Parameters

Parameter	Description	Required
logical1	The first condition to test.	Required
logical2	Optional additional conditions to test.	Optional

Basic Example

Check multiple conditions

=AND(A1>0, B1>0)

ResultTRUE

Returns TRUE only if both A1 > 0 and B1 > 0.

Advanced Examples

Example 1: AND with IF

Combined logic

Use AND within IF for multiple criteria

=IF(AND(A1>=18, B1="Yes"), "Eligible", "Not eligible")

Result: Eligible

Checks two conditions before returning a result.

How AND Works

AND evaluates all conditions and returns TRUE only when every condition is TRUE.

1

Define conditions

Determine all conditions that must be true.

2

Enter formula

Type =AND(condition1, condition2, ...).

3

Press Enter

The result is TRUE or FALSE.

Important Notes & Limitations

All conditions must be TRUE for AND to return TRUE.
For ANY condition being TRUE, use OR instead.

Common Errors & Fixes

#VALUE!Non-boolean arguments

Fix: Ensure all arguments evaluate to TRUE/FALSE.

Download Practice File

Practice AND with Real Data

Download a sample CSV file with pre-populated data and practice exercises for the AND function. Works in both Excel and Google Sheets.

Works in Google SheetsCompatible with ExcelIncludes exercises

File format: CSV (comma-separated values) - opens in Excel, Google Sheets, and all spreadsheet apps

Related Functions

FALSE

Returns the logical value FALSE.

IF

IF checks a condition and returns different values based on whether it is true or false.

IFERROR

IFERROR catches errors and returns a custom value instead.

IFNA

Replaces #N/A errors with a fallback value.

IFS

A simpler way to write multiple IF statements without nesting.

NOT

NOT flips TRUE to FALSE and FALSE to TRUE.

Frequently Asked Questions

How many conditions can AND handle?

AND can handle up to 255 conditions in Excel.

What if I have no conditions?

AND with no arguments returns TRUE.