AND
Combine several conditions so all of them must hold.
Syntax
AND(logical1, [logical2], ...)| Argument | Required | Description |
|---|---|---|
logical1 | Required | The first condition. |
logical2 | Optional | Further conditions. All must be true. |
Examples
Every example below was executed against VisiGrid engine 0.35.0 — not
transcribed from another vendor's documentation. Reproduce any of them with vgrid calc.
| Formula | Result | Notes |
|---|---|---|
=AND(TRUE,TRUE) | TRUE | |
=AND(TRUE,FALSE) | FALSE | |
=AND(A1>5,A4>5) | TRUE |
Almost always inside IF
AND on its own returns TRUE or FALSE, which is rarely the answer anyone
wants in a cell. Its job is to be the test:
=IF(AND(A1>5, B1="East"), "qualifies", "no")Note that AND takes conditions, not a range with a comparison —
AND(A1:A5>5) does not test each cell in turn. To ask whether every value in a
range passes, count the failures instead:
COUNTIF(A1:A5,"<=5")=0.
Excel compatibility
Matches Excel.