Checks if the value is #NULL!. If the argument evaluates to TRUE, the function returns the alternate value, otherwise it returns the value.
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!. |
| Col1 | Col2 | Formula | Description (Result) |
|---|---|---|---|
| #NULL! | 200 | =NZ([Col 1],[Col2]) | Checks whether the value in Col1 is the #NULL! error and returns the alternate value (200). |
| 400 | 450 | =NZ([Col 1],[Col2]) | Checks whether the value in Col1 is the #NULL! error and returns the alternate value (400). |