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>=70, C2="Complete")

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

AND caveats

AND is best for combining clear TRUE/FALSE tests. Most mistakes come from tests that do not return the logical value you expect.

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.