← Back to Number functions

Number.Isnull

This function checks if a value is null (not a number). It returns "true" if the number is equal to Number.IsNull, and "false" otherwise.

Syntax

Number.Isnull(number as number) as logical

About

This function checks if a value is null (not a number). It returns "true" if the number is equal to Number.IsNull, and "false" otherwise.

Explanation

Verify if the result of dividing 0 by 0 is null. Usage: Power Query MNumber.Isnull(0/0) Output: true Check if the result of dividing 1 by 0 is null. Usage: Power Query MNumber.Isnull(1/0) Output: false