Excel AND Function

AND returns TRUE only when every condition you give it is TRUE.

Use it when a spreadsheet decision depends on multiple requirements, such as status being complete, score meeting a threshold, and a date landing inside a valid window.

Build conditions Each test returns TRUE or FALSE

Check every test All tests must pass

Return one logical result TRUE only when all pass

AND syntax & arguments

Syntax

=AND(logical1, [logical2], ...)

Required Optional

1

logical1
Required

The first condition or logical value Excel should evaluate as TRUE or FALSE.
2

logical2
Optional Repeatable

Additional conditions or logical values that must also evaluate to TRUE.

Example

=AND(B2>=80, C2="Complete")

Return TRUE only when B2 is at least 80 and C2 is Complete.

AND caveats

AND returns TRUE or FALSE by itself

Use AND inside another function when you need a label, number, or alternate calculation instead of a logical value.
Every condition must be TRUE

One FALSE argument makes the entire AND formula return FALSE.
Comparisons should be explicit

Write tests such as B2>=70 or C2="Complete" so each argument has a clear TRUE/FALSE result.
Errors stop the result

If one logical argument returns an error, AND returns that error instead of ignoring it.

Need a custom output? Put AND inside IF when every condition must pass before returning a specific label or calculation. Use OR if you only care that at least one condition passes.