|
Evaluates a Boolean expression and returns one value if True (Then) and another if False (Else).
|
|
Syntax:
|
IF(Boolean, True Value, False Value)
|
|
Parameters:
|
Boolean: A Boolean expression that returns true or false.
Note: You can also use a logical variable that returns true or false.
True Value: The value returned if the expression evaluates to True.
False Value: The value returned if the expression evaluates to False.
|
|
Returns:
|
Returns a True value if the condition evaluates to True, otherwise it returns a False value.
|
|
Example:
|
IF(A=1,Blue,Green)
The expression returns Blue if A=1 (True) and returns Green if A does not =1 (False)
|
|
See also:
|
The Online and Rich Client Samples projects (program BS02 and RBS02)
|
