Syntax
DEFAULT(value, value_if_false)
Examples
Input |
|
Formula |
|
Output |
|
Input |
|
Formula |
|
Output |
|
Input |
|
Formula |
|
Output |
|
Input |
|
Formula |
|
Output |
|
Input |
|
Formula |
|
Output |
|
Input |
|
Formula |
|
Output |
|
DEFAULT
Allows you to specify a fallback in case a value doesn’t exist.
DEFAULT(value, value_if_false)
Input |
|
Formula |
|
Output |
|
Input |
|
Formula |
|
Output |
|
Input |
|
Formula |
|
Output |
|
Input |
|
Formula |
|
Output |
|
Input |
|
Formula |
|
Output |
|
Input |
|
Formula |
|
Output |
|