# AND

Formulas / AND
To test multiple logical conditions at the same time.
`AND(logical1, [logical2], ...)`
• logical1 - the first condition to test
• logical2,... - [OPTIONAL] additional conditions to test

## Examples

• `=AND(A2>1,A2<100)`

returns TRUE if A2 > 1 and A2 < 100. Otherwise, it returns FALSE.

• `=IF(AND(A21,A3<100),A3,"The value is out of range")`

returns the value in A3 if A21 is TRUE and A3 < 100. Otherwise, it returns "The value is out of range".

• `=AND(A4>B4,A4<C4)`

returns TRUE if A4 is greater than B4 AND A4 is less than C4. Otherwise, it returns FALSE.

• `=IF(AND(OR(A5,B5),C5),"YES","NO")`

returns "YES" if A5 OR B5 is TRUE AND C5 is TRUE. Otherwise, it returns "NO".

• `=AND(1,TRUE,FALSE)`

returns FALSE because one of the conditions is FALSE.

## Summary

The AND function is used to test multiple conditions and returns TRUE if all conditions are met.

• The AND function is a logical function that requires more than one condition. It returns TRUE if all arguments evaluate to TRUE.
• The AND function does not support wildcards and returns #VALUE if no logical values are found or created during evaluation.
• AND is not case-sensitive and ignores text and empty cells.