IFERROR (PQL - xl)

This function evaluates a formula and returns a value you provide if there is an error or the formula result

  • Library: PQL \ Spreadsheet \ Logical
  • Compatibility: Any content (regardless of data source) in the Tabulate spreadsheet module
  • Solve: This function can be used with the Solve plug-in: both as part of the objective function and constraint functions

Syntax

IFERROR(value, value if error)

Function Arguments

Name

Description

Type

Optional

value

Value or expression to evaluate

StringOrNumber

value if error

Value to return if the formula returns an error

StringOrNumber

Comments

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