AND(<List>)

 

Description

This function returns 1 if all arguments are 1; 0 if any argument is 0; -1 otherwise.

 

Parameters

 

<List>

Any combination of numbers, cells, or ranges.

 

Examples

 

Given:

 

A1=1, B1=1, C1=0, D1=0, E1=1 and A2=24.

 

AND(A1, B1) = 1

 

AND(A1:E1) = 0

 

AND(A1:A2) = -1