Checks if the value is #NULL!. If the argument evaluates to TRUE, the function returns the alternate value, otherwise it returns the value.
Use NZ to replace #NULL! with a meaningful value, such as a message, in your calculated column.
Syntax
NZ(value,alternate)
|
Argument |
Description |
|
value |
Can be a column reference. If value is #NULL!, the function returns the value in alternate. Otherwise, it returns value. |
|
alternate |
Can be numbers, text, or column references. The value in alternate is returned if value is #NULL!. |
Example
|
Col1 |
Col2 |
Formula |
Description (Result) |
|
#NULL! |
“No value found” |
NZ([Col1],[Col2]) |
Checks whether the value in Col1 is the #NULL! error and returns the alternate value (“No value found”) |
|
400 |
450 |
NZ([Col1],[Col2]) |
Checks whether the value in Col1 is the #NULL! error and returns the value (400) |
