@isna(expression)

Definition

Is not available

Can be used in @if statements.

Returns

True—if the expression is undefined or not a number
False—if not

Example 1

@isna(1/0)

The answer to the expression is undefined, soStrategic Finance returns true.

Example 2

@if(@isna(v2040/v1040), v2040/v1040, 0)

With Inventory (v2040) and Cost of Goods (v1040), this formula returns the inventory turnover when Cost of Goods Sold does not equal zero and 0 when Cost of Goods Sold does equal 0 or is N/A.