Help Centre › Functions & Formulas
For a full list of available calculation functions, please read What calculation functions are supported.
This article describes the formula syntax and usage of the IFNULL function.
Description
Returns the first argument if it is not null, otherwise it returns the second argument.
Syntax
IFNULL(expression, value_if_null)
The IFNULL function syntax has the following arguments:
- expression - Required. The expression to test for null.
- value_if_null - Required. The value to return if expression is null.
Example
| Formula | Description | Result |
| =IFNULL(A1, "No Value") | If A1 is null, returns "No Value". | No Value |
| =IFNULL(5, 10) | If 5 is not null, returns 5. | 5 |
Errors
For a full list of formula errors, please read Formula errors.