Null function

Returns the value #NULL!.

Use the NULL function to indicate empty values in a calculated column. By using NULL, you can avoid the problem of unintentionally including empty values in your calculations. When a formula refers to a cell containing #NULL!, the formula returns #NULL!.

Syntax

NULL()

Remarks

The NULL function syntax has no arguments. You must include the empty parentheses with the function name.

Top of Page