NULL function

Applies To
SharePoint Server 2019 SharePoint Server 2016 SharePoint Server 2013 SharePoint Server 2013 Enterprise SharePoint Foundation 2010 SharePoint Server 2010

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