Reference Property Arguments

A reference property argument specifies how to treat formula reference results and is used in conjunction with the other properties.

There is one reference property argument: IfNonNumber/IFFN.

IfNonNumber specifies a replacement for #Missing and #Error values with a specific numeric value.

The syntax is:

AXIS[segment(range)].IfNonNumber(arg).AggregateProperty
         

Table -8 Argument Components

Argument	Description
AXIS	(Optional) A row, column, or cell keyword.
Segment(range)	Any axis reference, such as a row number or column letter.
IfNonNumber	How to treat missing or error data within the AxisRef.
(arg)	What number to use if missing or error data is encountered within the AxisRef.
AggregateProperty	(Optional) The aggregate function used for aggregate segments. See Aggregate Property Arguments.

For example:

If cell[1,A] = 3 and cell[1,B] = #Missing,

The following expression returns #Error:

  cell[1,A] / cell[1,B] 

The following expression replaces cell[1,B] with 1 and returns 3:

  cell[1,A] / cell[1,B].ifNonnumber(1)

Note:

If you use suppression for #Missing or #Error in a grid, and the grid contains a formula row or column that uses the IfNonNumber property, #Missing and #Error remain suppressed.