AND function

Userlevel 5

+8

This article describes how to use the AND function, the syntax around it, and some examples.

Description

Tests to see if all conditions are met.

logical1 AND logical2...

Boolean (TRUE or FALSE)

Case	Returns	Return Type
`x > 1000 AND y > 1000`	`TRUE` if both x and y are above 1000, `FALSE` otherwise	`boolean`
`TRUE AND TRUE`	`TRUE`	`boolean`
`TRUE AND FALSE`	`FALSE`	`boolean`
`True AND Blank`	`Blank`	`boolean`
`Blank AND FALSE`	`Blank`	`boolean`
`Blank AND TRUE`	`Blank`	`boolean`

Excel equivalent: AND(logical1, [logical2], ...)

See also: OR, NOT, TRUE, FALSE

This topic has been closed for comments