=AND(logical1, [logical2], ...)
Description
Returns TRUE if all its arguments evaluate to TRUE; returns FALSE if one or more arguments evaluate to FALSE.
Syntax
AND(logical1, [logical2], ...)
The AND function syntax has the following arguments:
logical1 Required. The first condition that you want to test that can evaluate to either TRUE or FALSE.
logical2, ... Optional. Additional conditions that you want to test that can evaluate to either TRUE or FALSE, up to a maximum of 255 conditions.
Remarks
Example 1
5 DATA
6 50
7 104
Note: number 5 through 7 are rows and DATA, 50, 104 are values of column A.
=AND(1>A6, A6<100)