If
Use this function to carry out a set of instructions if a condition is TRUE.
Do not confuse the If function with the When function:
| Function | Description |
|---|---|
If |
To carry out a set of instructions if any value of a symbol matches a condition. |
When |
To carry out a set of instructions each time the contents of a cell match a condition. |
Syntax:
IF Condition
Instructions
[ELSE
Instructions2]
END IF
where:
- Condition is a test to determine if a relationship is true or false. Your system applies the If condition to all data cells, and is considered TRUE if the condition is TRUE for any single value. (You can also compare a constant against another constant.) If Condition is TRUE, your system carries out Instructions.
- Instructions is a set of instructions that your system carries out if Condition is TRUE.
Syntax example:
IF VALUE(WDGTMFG, A20000, AYR01) LT 0.2 * VALUE(WDGTMFG, A99999, AYR01)
Div = 0.1 * A99999
END IF