- Help Center
- Operations
- Logical
IFNULL Operation
How to use the IFNULL operation in formulas
Definition
The IFNULL operation allows you to define the output for a field that is null.
Example
IFNULL(NULL, Not Defined)
Result:
Not Defined
Syntax Guide
IFNULL(value1, value_if_null)
value1 - The value to test
value_if_null- The value to return if value1 is NULL
Formula In Use
What's Next?
- Learn more about how to write formulas
- Check out the NOT operation
- Check out the OR operation