IFNULL Operation

Definition

Example

Syntax Guide

Formula In Use

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