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.