Excel Function

AND

Returns TRUE when all conditions are TRUE.

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

Arguments

logical1

Required

Enter the first condition expression.

logical2

Optional

Enter the second condition expression.

Practice Preview

Use AND to check whether both cell B2 (Score in column B) is greater than or equal to 80 and cell C2 (Attendance Rate in column C) is greater than or equal to 97 are true.

Example Table

#	ALearner ID	BScore	CAttendance Rate
2	U001	82	96
3	U002	67	87
4	U003	91	99
5	U004	55	72
6	U005	78	90
7
8

How to Use (Formula)

=AND(B2>=80, C2>=97)

Result

FALSE

Practice This Function

Start Function Practice Back to Function List

AND FAQ

How do I use AND in Excel?

Use AND when you want to check whether multiple conditions are all true. Enter Logical test 1, Logical test 2 in that order, then add optional arguments when needed.

Where can I practice AND?

Use the "Start Function Practice" button to jump straight into AND drills.

What arguments does AND use?

The main arguments are Logical test 1, Logical test 2. Start with the required ones, then add optional arguments if needed.