Excel AND() Function

The AND() function in excel tests the multiple sets of conditions and returns TRUE if all supplied conditions met the criterion, FALSE otherwise. You need to have a minimum of 2 conditions to check.

Syntax

AND(Logical 1, Logical 2, Logical 3, and soon..)

Parameter

Logical1 (required)- This parameter represents the first condition that needs to be checked.

Logical 2(optional)- This parameter represents the second condition, which needs to be checked.

….(optional)- It represents the other conditions that need to be checked.

Category

Logical

Return

The function returns a Boolean value TRUE, and if all arguments are true, else it returns FALSE.

Example 1

Objective: Test condition 1 and condition 2 to check whether the numbers are greater than 0 or not by using AND function.

Condition 1	Condition 2	Result	Formula
11	21	TRUE	=AND(A19>0,B19>0)
1	-2	FALSE	=AND(A20>0,B20>0)

Example 2

Objective: Return TRUE if COL A is greater than COL B and COL B is less than COL C

Col A	Col B	Col C	Result	Formula
167	502	61	FALSE	=AND(B131>C131,C131<D131)
903	895	967	TRUE	=AND(B132>C132,C132<D132)

Example 3

Objective: Using the IF with AND function, check whether the student has passed or not. If the student has failed in 1 of the 2 subjects, then the student will be considered as Failed.

Student Name	Subject 1	Subject 2	Overall Result	Formula
Reeta	PASS	PASS	PASS	=IF(AND(B26="PASS",C26="PASS"),"PASS","FAIL")
Sweta	PASS	FAIL	FAIL	=IF(AND(B27="PASS",C27="PASS"),"PASS","FAIL")
Baani	FAIL	PASS	FAIL	=IF(AND(B28="PASS",C28="PASS"),"PASS","FAIL")
Aditya	PASS	PASS	PASS	=IF(AND(B29="PASS",C29="PASS"),"PASS","FAIL")