This page isn't translated yet, so its text is in English. Function names and formulas are shown in your Excel language.

Excel function · Logic

AND

Returns TRUE only when every test is true.

What it does

AND checks two or more tests and returns TRUE if all of them are TRUE. It's most often used inside IF, to require several things at once.

=AND(logical1; [logical2]; …)

Arguments in square brackets are optional, and … means you can add more of the same. In this Excel language, arguments are separated by ;

A good walking day is between 15 and 25 degrees. Is 21 degrees one?

	A	B
1	Temp (°C)	Walking weather?
2	21	TRUE

The formula in B2:

=AND(A2>=15;A2<=25)

Result: TRUE

21 is at least 15 and at most 25, so both tests are TRUE and AND returns TRUE.

Writing a between test as one comparison, the way you would on paper. Excel needs two separate tests inside AND.
Expecting a word as the answer. AND only returns TRUE or FALSE; wrap it in IF to show Yes or No.

Excel translates function names, and in some languages the argument separator too. Type the name your Excel shows.