Evaluates the expression and returns the value depending on the result of the evaluation.
= IF(expression, value1, value2)
|
expression |
An expression which is to be evaluated. The expression can be specified as an equality (e.g., USERNAME() = “lskywalker”), an inequality (e.g., Quantity>10), as a comination of expressions (e.g., USERNAME() = “lskywalker” OR Quantity>10). |
|
Example |
Returns |
|
= IF(USERNAME() = “lskywalker”, “Luke”, “Anakin”) |
“Luke” if expression evaluates to True else returns “Anakin”. |
|
= IF(Quantity > 10, 10, 5) |
10 if quantity is more than 10, else returns 5. |
|
= IF(BirthDate >= Today(), “The BirthDate should be lesser than the system date", “Valid Date”) |
|
|
= IF(ROLEID = 6, “Customer Support”, ““) =IF(PARSEINTEGER(Order_DetailsTableControlRow.Quantity.Text) < 0, "<font color='red'>" + Order_DetailsTableControlRow.Quantity.Text + "</font>", Order_DetailsTableControlRow.Quantity.Text) |
|