## Saturday, January 8, 2022

### AND function [MS]

Returns the logical value TRUE or Yes if all of the arguments evaluate to TRUE; returns FALSE or No if one or more arguments evaluate to FALSE.

## Syntax

AND(logical1,logical2,…)

Logical1,Logical2,…    are 1 to 30 conditions you want to test that can be either TRUE or FALSE.

## Remarks

• The arguments must evaluate to logical values such as TRUE or FALSE, or the arguments must be column references that contain logical values.

• If a column reference argument contains text, AND returns the #VALUE! Error value; if it is empty, it returns FALSE.

• If the arguments contain no logical values, AND returns the #VALUE! error value.

• If one or more arguments contain #NULL!, AND returns #NULL!.

## Example 1

 Formula Description (Result) =AND(TRUE,TRUE) All arguments are TRUE (Yes) =AND(TRUE,FALSE) One argument is FALSE (No) =AND(2+2=4,2+3=5) All arguments evaluate to TRUE (Yes) =AND(TRUE,#NULL!) One argument contains #NULL!(#NULL!)

## Example 2

 Col1 Col2 Formula Description (Result) 50 104 =AND(1<[Col1], [Col1]<100) Because 50 is between 1 and 100 (Yes) 50 104 =IF(AND(1<[Col2], [Col2]<100), Displays the second number, if it is between 1 and 100, otherwise displays a message (The value is out of range.) 50 104 =IF(AND(1<[Col1], [Col1]<100), [Col1], "The value is out of range.") Displays the first number, if it is between 1 and 100, otherwise displays a message (50)