Function Index

IsNotNull

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

Usage

IsNotNull(<argument>)

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


Examples

IsNotNull([Sales])
  • Function will return True for rows where sales data exists and False 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.