IF
- Last UpdatedMar 20, 2025
- 1 minute read
The IF() function produces a stream based on the results of a logical expression.
Syntax
|
Format |
Stream = IF( LogicalExpression, TrueStream, FalseStream ) |
|
Arguments |
LogicalExpression - A logical expression to be evaluated TrueStream - A stream of values from which to select when the expression evaluates to TRUE FalseStream - A stream of values from which to select when the expression evaluates to FALSE |
|
Description |
When the LogicalExpression evaluates to a true value, the corresponding value from TrueStream is selected for the output stream. Otherwise, the corresponding value from the FalseStream is selected. |
|
Format |
Stream = IF( LogicalExpression, TrueStream ) |
|
Arguments |
LogicalExpression - A logical expression to be evaluated TrueStream - A stream of values from which to select when the expression evaluates to TRUE |
|
Description |
When the LogicalExpression evaluates to a true value, the corresponding value from TrueStream is selected for the output stream. Otherwise, a NULL or "bad quality" value is selected. |
|
Format |
Stream = IF( LogicalExpression ) |
|
Arguments |
LogicalExpression - A logical expression to be evaluated |
|
Description |
Produces an output stream of Boolean values representing the results of LogicalExpression. |