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
Drag to adjust the number of frozen columns
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