Autonumber
Formula Reference
Description (from Formula Reference)
1
1
BLANK()

Returns a blank value.

2
2
TRUE()

Logical value true. The value of true is represented numerically by a 1.

3
3
FALSE()

Logical value false. False is represented numerically by a 0.

4
4
AND()

Returns true if all the arguments are true, returns false otherwise.

5
5
OR()

Returns true if any one of the arguments is true.

6
6
NOT()

Reverses the logical value of its argument.

7
7
XOR()

Returns true if an odd number of arguments are true.

8
8
IF()

Returns value1 if the logical argument is true, otherwise it returns value2. Can also be used to make nested IF statements.

Can also be used to check if a cell is blank/is empty.

9
9
SWITCH()

Takes an expression, a list of possible values for that expression, and for each one, a value that the expression should take in that case. It can also take a default value if the expression input doesn't match any of the defined patterns. In many cases, SWITCH() can be used instead of a nested IF() formula.

10
10
>

Compare if one value is greater than another value.

Cannot adjust frozen columns; click to learn more or reset
Type (from Formula Reference)
Example text
Example number
BLANK()
FALSE()
TRUE()
AND(expression, exp2, ...etc.)
AND() Example 2
OR(expression, exp2, ...etc.)
OR() Example 2
NOT(expression)
NOT(expression) Example 2 - check out the formula!
XOR(expression, [exp2, ...])
XOR() Example 2 - check out the formula!
IF() Example 2 - check out the formula!
IF(expression, ifTrue, ifFalse)
SWITCH(expression, [pattern, result ... , default])
SWITCH() Example 2 - check out the formula!
Logical functions
apples and bananas
42
Logical functions
apples and bananas
42
Logical functions
apples and bananas
42
Logical functions
apples and bananas
42
Logical functions
apples and bananas
42
Logical functions
apples and bananas
42
Logical functions
apples and bananas
42
Logical functions
potato
101
Logical functions
puppy
0
Logical operators
15 records
Extensions

Alert

Lorem ipsum
Okay