Manuals/calci/IFNULL

IFNULL (Value,Default)

Where

• $Value$ and Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle Default}
  • IFNULL() used to returned the given values according to the Null values.

Description

IFNULL (Value,Default)

• $Value$ and $Default$ are any two values.This function takes two arguments.
• If the first argument is not NULL, the function returns the first argument. Otherwise, the second argument is returned.
• This function is commonly used to replace NULL value with another value.

Examples

1. IFNULL(90,3) = 90
2. IFNULL(#,54)= 54
3. IFNULL("@",1) = @

Related Videos

Null

See Also

• NULL
• IF
• AVERAGEIF

References

• IfNull

• List of Main Z Functions

• Z3 home