Navigation:  Module 1 - Energy Accounting > Accounts & Invoices Tab > User Defined Components > Functions >

Inline If

Previous page Next page
  rev. 2011-02-09        

Inline If

Description:

Returns one of two values, depending on the evaluation of an expression.

Syntax:

iif(expression, trueValue, falseValue)

Type:

Any kind of object.  Depends on trueValue and falseValue

Arguments:

Argument

Description

expression

Expression you want to evaluate

trueValue

Value returned if expression is True

falseValue

Value returned if expression is False

Examples:

Expression

Result

iif(1>0,One is greater than zero,One is less than zero)

One is greater than zero



S2_IIF_Function         ©2014 Managing Energy Inc.