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.