Office
Sign in

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

Expand your Office skills
Explore training
Get new features first
Join Office Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.

×