If

Description

Returns the value of the TrueResult parameter if the specified expression evaluates to True. Otherwise, it returns the value of the FalseResult parameter.

Syntax

If(Expression:Boolean, TrueResult:String,FalseResult:String):String

Expression is a Boolean expression to evaluate.

TrueResult is the string value to return if the condition is True.

FalseResult is the string value to return if the condition is False.

Example

If(Equals(String,Descr(),),Abbrev(),Concat(Abbrev,-,Descr()))

If the node name is Colas and the current node description is blank, then the return value is Colas.

If the node name is 100 and the current node descriptions is Colas, then the return value is 100–Colas.