AND function
From Apache OpenOffice Wiki
< Documentation | How Tos
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.
AND
Returns TRUE if all the arguments are considered TRUE, and FALSE otherwise.
Syntax:
AND(argument1; argument2 ...argument30)
argument1 to argument30 are up to 30 arguments, each of which may be a logical result or value, or a reference to a cell or range.
AND tests every value (as an argument, or in each referenced cell), and returns TRUE if they are all TRUE. Any value which is a non-zero number or text is considered to be TRUE.
Example:
If cells A5:B8 all contain TRUE, cell C2 contains =TRUE() and cell C3 contains "dog":
AND(2<4;A5:B8;C2)
- returns TRUE.
AND(2<4;FALSE)
- returns FALSE.
AND(C2:C3))
- returns TRUE.
See Also
