Nz function

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)

Top of Page