The If function returns one of two values, depending on a given condition.
Syntax
|
|
The If function returns one of two values, depending on a given condition. |
|
|
If(condition, returnTrueValue, returnFalseValue) |
|
|
Arguments: |
|
|
|
condition |
Boolean - The condition. |
|
|
|
returnTrueValue |
Any - The value to return when the condition is true. |
|
|
|
returnFalseValue |
Any - The value to return when the condition is false. |
Remarks
- Example: If(BI_PD.Premium < 10000, 10000, BI_PD.Premium) returns 10000.
Comments
0 comments
Article is closed for comments.