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

Returns a blank value.

Logical functions
2
2
TRUE()

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

Logical functions
3
3
FALSE()

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

Logical functions
4
4
AND()

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

Logical functions
5
5
OR()

Returns true if any one of the arguments is true.

Logical functions
6
6
NOT()

Reverses the logical value of its argument.

Logical functions
7
7
XOR()

Returns true if an odd number of arguments are true.

Logical functions
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.

Logical functions
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.

Logical functions
10
10
>

Compare if one value is greater than another value.

Logical operators
11
11
<

Compare if one value is less than another value.

Logical operators
12
12
<=

Compare if one value is less than, or equal to, another value.

Logical operators
13
13
!=

Check if one value is not equal to another value.

Logical operators
14
14
=

Compare if one value is equal to another value.

Logical operators
15
15
>=

Compare if one value is greater than, or equal to, another value.

Logical operators
Cannot adjust frozen columns; click to learn more or reset
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!
apples and bananas
42
0
1
1
1
1
1
0
0
0
1
I love fruits
this is 42!
meaning of life
7
apples and bananas
42
0
1
1
1
1
1
0
0
0
1
I love fruits
this is 42!
meaning of life
7
apples and bananas
42
0
1
1
1
1
1
0
0
0
1
I love fruits
this is 42!
meaning of life
7
apples and bananas
42
0
1
1
1
1
1
0
0
0
1
I love fruits
this is 42!
meaning of life
7
apples and bananas
42
0
1
1
1
1
1
0
0
0
1
I love fruits
this is 42!
meaning of life
7
apples and bananas
42
0
1
1
1
1
1
0
0
0
1
I love fruits
this is 42!
meaning of life
7
apples and bananas
42
0
1
1
1
1
1
0
0
0
1
I love fruits
this is 42!
meaning of life
7
potato
101
0
1
1
0
1
0
0
0
0
1
Wait this isn't a fruit!
this is not 42
number of dalmations
14
puppy
0
0
1
0
0
1
0
0
0
1
1
Wait this isn't a fruit!
this is not 42
zero!
21
0
1
0
0
0
0
0
1
0
0
Wait this isn't a fruit!
this is not 42
0
1
0
0
0
0
0
1
0
0
Wait this isn't a fruit!
this is not 42
0
1
0
0
0
0
0
1
0
0
Wait this isn't a fruit!
this is not 42
0
1
0
0
0
0
0
1
0
0
Wait this isn't a fruit!
this is not 42
0
1
0
0
0
0
0
1
0
0
Wait this isn't a fruit!
this is not 42
0
1
0
0
0
0
0
1
0
0
Wait this isn't a fruit!
this is not 42
15 records
Extensions

Alert

Lorem ipsum
Okay