Returns True if the argument is Null (does not contain valid data), and False otherwise.

Usage

IsNull(argument)

argument (required) Any argument can be provided. The function can analyze one argument at a time. IsNull is often applied to column of data to test for Null values.

Example

IsNull([Sales])
  • Function will return False for rows where sales data exists and True for rows where there is no data.

See Also


Was this page helpful?
Yes No