COALESCE

The COALESCE function returns the first non-null value in a list of values.

Syntax

=COALESCE(value1, [value2], ...)

Parameters

• value1: The first value to check
• value2, ...: Additional values to check (optional)

Examples

=COALESCE(NULL, "Hello", "World") // Returns "Hello"
=COALESCE(NULL, NULL, 123) // Returns 123