AND
Definition of AND:
Returns true if all of the provided arguments are logically true, and false if any of the provided arguments are logically false.
Sample Usage
AND(A2 = "foo", A3 = "bar")
AND(TRUE,FALSE,TRUE)
AND(A1:A10,B1:B10)
AND(0,1,2,3)
Syntax
AND(logical_expression1, [logical_expression2, ...])
logical_expression1
- An expression or reference to a cell containing an expression that represents some logical value, i.e.TRUE
orFALSE
, or an expression that can be coerced to a logical value.logical_expression2, ...
- [ OPTIONAL ] - Additional expressions or references to cells containing expressions representing some logical values, i.e.TRUE
orFALSE
, or expressions that can be coerced to logical values.
Notes
- The number 0 is logically false; all other numbers (including negative numbers) are logically true.
Step 1. To use the AND Formula, start with the Excellentable you would like to edit.
Step 2. Then type the AND formula into the cell you have chosen to display the outcome:
Step 3. Fill in the 2 values- In this formula there are four possible cases.
- logical1 = TRUE and logical2 = TRUE
- logical1 = FALSE and logical2 = TRUE
- logical1 = TRUE and logical2 = FALSE
- logical1 = FALSE and logical2 = FALSE
By adding the values you would like to calculate, Excellentable generates the outcome:
See Also
OR
: Returns true if any of the provided arguments are logically true, and false if all of the provided arguments are logically false.
NOT
: Returns the opposite of a logical value - `NOT(TRUE)` returns `FALSE`; `NOT(FALSE)` returns `TRUE`.