The Null() function returns an array with one element representing a missing value. It is commonly used to:

• Populate empty cells with a specified value.
• Recognize unpopulated cells in Excel.

Syntax:

Qx.Null()

• In Excel with Quintessence add-in versions prior to 25.1, use: Null()
• In the Quintessence Editor (Studio) using Quintessence language, use: Null()
• In the Quintessence Editor (Studio) using Python language, use: Qx.Null()

Examples:

The examples provided below are based on fictitious data for illustrative purposes only.

=Qx.SubstituteArray(A1:B6, "Weekend", Qx.Null())