IF (PQL - xl)

This function performs a comparison and returns one of two provided values based on that comparison

  • 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

IF(logical test, value if true, value if false)

Function Arguments

Name

Description

Type

Optional

logical test

Value or expression to evaluate

StringOrNumber

value if true

Value to return if the test evaluates to true

StringOrNumber

value if false

Value to return if the test evaluates to false

StringOrNumber

Comments

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