Formula Playground
Copy base
Report abuse
Views
Autonumber
Formula Reference
1
1
BLANK()
2
2
TRUE()
3
3
FALSE()
4
4
AND()
5
5
OR()
6
6
NOT()
7
7
XOR()
8
8
IF()
9
9
SWITCH()
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!
Description (from Formula Reference)
Type (from Formula Reference)

Returns a blank value.

Logical functions
apples and bananas

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

Logical functions
apples and bananas

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

Logical functions
apples and bananas

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

Logical functions
apples and bananas

Returns true if any one of the arguments is true.

Logical functions
apples and bananas

Reverses the logical value of its argument.

Logical functions
apples and bananas

Returns true if an odd number of arguments are true.

Logical functions
apples and bananas

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
potato

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
puppy
15 records
  • All — use the below views to filter between examples!
  • BLANK()
  • TRUE()
  • FALSE()
  • AND()
  • OR()
  • NOT()
  • XOR()
  • IF()
  • SWITCH()
Extensions

Alert

Lorem ipsum
Okay