If

Returns a value based on the testing of multiple logical values.

If Test evaluates to True, the value returned is that of the second parameter (the “Then” expression).

If Test is a numeric expression, then any value other than zero is considered to be True. If Test is a string expression, any value other than the null string is considered to be True.

If Test evaluates to False and only three parameters were specified, the value returned is that of the third parameter (the “Else” expression).

If more than three parameters were specified, then if the “ElseIf” expression evaluates to True, the value returned is that of the subsequent “Then” expression, and so on.

If(Test,Then,Else)
If(Test,Then,ElseIf,Then,Else)
If(Test,Then,ElseIf,Then,ElseIf,Then,Else)

Up to a total of 11 parameters

IsEmpty

Returns 1 if String = "", else 0.

IsEmpty(String)

Example

R.Skill.GT(5,n)!= ““ & IsEmpty(R.Skill.GT(5,n+1))
is true if exactly n acquired resources have a Skill > 5

See also .GT for more examples.

IsNum

Returns 1 if Value is numeric; returns 0 if non numeric.

IsNum(Value)

IsString

Returns 1 if Value is a string; returns 0 if numeric.

IsString(Value)

Select

Returns a value based on an integer index. If CaseNum is 0, the value of Case0 is returned; if CaseNum is 1, the value of Case1 is returned, and so on. If CaseNum is out of bounds, the value of Default is returned.

Select(CaseNum,Case0,Default)
Select(CaseNum,Case0,Case1,Default)
Select(CaseNum,Case0,Case1,Case2,Default)

Up to a total of 12 parameters

Switch

Returns a value based on multiple logical comparisons. If SwitchValue is equal to Value1, the value of Result1 is returned, else if SwitchValue is equal to Value2, the value of Result2 is returned, and so on. If none of the Values are equal to SwitchValue, the value of Default is returned.

Switch(SwitchValue,Value1,Result1,Default)
Switch(SwitchValue,Value1,Result1,Value2,Result2,Default)
Switch(SwitchValue,Value1,Result1,Value2,Result2,Value3,Result3,Default)

Up to a total of 12 parameters