Export (0) Print
Expand All
Expand Minimize

WorksheetFunction.IfNa Method (Excel)

Office 2013

Returns the value you specify if the expression resolves to #N/A, otherwise returns the result of the expression.

Version Added: Excel 2013

expression .IfNa(Arg1,Arg2)

expression A variable that represents a WorksheetFunction Object (Excel) object.

Parameters

Name

Required/Optional

Data type

Description

Arg1

Required

VARIANT

value: Any value or expression or reference.

Arg2

Required

VARIANT

value_if_na: Any value or expression or reference.

Return value

VARIANT

Show:
© 2014 Microsoft