IF, ELSE, ELSEIF, ENDIF

Conditional execution of statements.

Syntax:

IF(parameter)

When IF has only a single parameter, it signals the start of an IF ... ENDIF sequence. The parameter is a condition: if it is true, execution follows on the following line; if it is false, execution continues after the next ELSE, ELSEIF or ENDIF statement that follows. For example:

  IF(@parameter_1 > 10)
    SET_VALUE(C10, 1)
  ELSEIF(@parameter_1 > 8)
    SET_VALUE(C12, 1)
  ELSEIF(@parameter_1 > 6)
    SET_VALUE(C14, 1)
  ELSE
    SET_VALUE(C16, 1)
  ENDIF
  

ENDIF marks the end of the sequence, ELSEIF marks the beginning of a second condition, and ELSE a statement to be executed if the preceding conditions evaluated to FALSE.

You can nest IF statements inside each other, (and usually should) use spaces to make IF statements more readable:

  IF(A15 > B15)
    IF(TYPE(DEREF(C16))="error")
      RESULT("Bad value")
    ENDIF
    C16+4+SUM(E1:E10)
  ENDIF
  

Syntax:

IF(parameter_1, parameter_2 {, parameter_3})

If the condition expressed in parameter_1 is true, then parameter_2 is executed. If it is false, execution continues or if a third parameter is supplied, that is executed. You need not use an ENDIF statement to mark the end of the sequence.

Examples:

IF(B3 > 7, RESULT(C3))

IF(B5 = 2,, BREAK)

IF(@num <= 0, RESULT(1), RESULT(@num))