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.

 

Example

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

See Also

Was this article helpful?

Anything else?

Our customer support team is here to help.

Contact Us