- 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
If you have any questions just click on the chat box in the bottom-right corner and we'll be happy to answer them...
and please let us know 👇