Manuals/calci/AND
AND (L1, L2 ...)
Where L1, L2 … are positive integers.
And is a function which returns as 1(TRUE) when all its arguments are 1 (TRUE). If one or more argument is 0(FALSE), then AND is calculated as 0(FALSE).
If both the logical values are 1(TRUE), then AND value also should be 1 and either of the logical value is 0(FALSE), then the AND value is 0
AND
Lets see an example
AND (L)
=AND (1,1) is 1 ie, TRUE and =AND(1,0) is 0. ie, FALSE
B
55
110
=AND(1<B3,B3<100) is 1(TRUE)
=IF(AND(1<B4,B4<100, B4, "The value is out of range.") is out of range
Syntax
Remarks
Examples
Description
| Column1 | Column2 | Column3 | Column4 | |
| Row1 | 1 | 0 | ||
| Row2 | 55 | |||
| Row3 | 110 | |||
| Row4 | 1 | |||
| Row5 | The value is out of range. | |||
| Row6 |
