Logical Function AND() & OR() in Excel

The AND formula returns TRUE if all arguments are TRUE and returns FALSE if one or more arguments are FALSE. The OR formula returns TRUE if at least one argument is TRUE and only returns FALSE if all arguments are FALSE.

AND(logical1,logical2, ...)

OR(logical1,logical2, ...)

EXAMPLE:

Assuming cell A2 has a value of 110 and cell A3 has a value of 104, the following formulas and their respective answers:

=AND(A2<100,a3>100) Ans: TRUE

=AND(A2>110,A3>100) Ans: FALSE

=OR(A2<100,a3>100) Ans: TRUE

=OR(A2>110,A3>100) Ans: TRUE

=IF(OR(A2<110,a3>100),”Big”,”Small”) Ans: Big

Please note > is greater than, >= is greater than or equal to

Keyword: Logical