Function Index

IsNull

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.

Examples

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

More About

Logical Functions

Logical functions test for True/False values. They evaluate a condition, and return a value based on whether the condition is True or False.