IFNA (PQL - xl)

This function calculates the specified value if the formula returns #N/A error, otherwise it returns the actual result of the formula

  • Library: PQL \ Spreadsheet \ Logical
  • Compatibility: Any content (regardless of data source) in the Tabulate spreadsheet module

Syntax

IFNA(value, value if na)

Function Arguments

Name

Description

Type

Optional

value

Refers to a number, or expression that needs to be tested

StringOrNumber

value if na

Refers to an alternate number, or expression that is returned if value returns #N/A error

StringOrNumber

Comments

This function is the same as the Microsoft Excel 'IFNA' function - using the same inputs, logic and outputs.