Syntax
Coalesce(Value1 [, Value2, ...])Examples
=Coalesce(Nickname, FullName, "Guest")The first value that isn’t empty
Maker notes
- Empty strings count as blank, so this is a tidy way to supply a fallback value.
Coalesce
Returns the first argument that is not blank or an empty string.