Inserting IF Statements

This section describes how to create an IF statement. You can use operators to define multiple conditions or identify outcomes that must never occur:

To define one condition out of many that must be met, click the must occur button,.
To define a condition that cannot occur, click the must never occur button,.
Review the information that you must specify to create an IF statement. See Syntax and Placeholders.

To insert an IF statement:

Select Functions, thenLogical, and double-click IF.
This inserts IF(conditon, then, else)
Place the cursor after the open bracket and replace condition with the function that retrieves the values to use.
For example, if the condition involves scorecard scores, insert sScore
Select the object whose values you want to use from the box that is displayed.
Press ENTER to insert an empty line.
Optional: Define another condition and press ENTER.
Indent the cursor and replace then with the value or function to use if the condition(s) ares true.
Press ENTER to insert an empty line.
Indent the cursor and replace else with the function or value to use if the THEN outcome is false.