Logical Functions | ATX AnalyticsTable Docs

Logical FunctionsSyntax, arguments and examples for every function in the Logical category. Formulas start with =. Cells are addressed by column and row, for example C3R5 (column 3, row 5); a range such as C3R1:C3R10 runs down a column. Type a formula into a cell, or into the formula bar (Functions → Formula Bar → Formula Bar). TRUE when every argument is true, FALSE as soon as one is not. Takes any number of arguments, and a range counts as all of its values — =AND(C1R1:C1R10) asks whether all ten hold. An empty range is TRUE, which is what keeps a formula over a range that has not filled up yet from reading as a failure.

Settings and controls documented

condition
value if true
value if false
value
value if error

Full page

The full page — procedures and the explanation of every setting — is available to signed-in users.

Previous — Statistical Functions
Next — Text Functions
ATX AnalyticsTable documentation — all pages
Sign in to read the full documentation

ATX Institute on LinkedIn

This site needs JavaScript for the full experience. Every page above is reachable without it.