IF Function is now available as a formula for Calculated and Text fields. The IF function gives two values, depending on the evaluation of the formula. If the evaluation results in “true, ” then it gives one value. If the evaluation is “false, ” it gives a different value.
Available operators: less than (<), less than or equal to (<=), greater than (>), greater than or equal to (>=), equal to (=), and not equal to (!=) or (<>).
Example: Shipping is equal to "$5" if subtotal is "< $20," "$0" if subtotal is "≧ $20."
Using IF with AND, OR, and NOT Functions:
IF(AND(logic1, logic2, logic3…), true value, false value)
If all of the logic is “true,” then it will return “true value.” If any of the logic is “false,” then it will return “false value.”
IF(OR(logic1, logic2, logic3…), true value, false value)
It will return “true value” if any of the logic is “true,” and “false value” if all of the logic is false.
IF(NOT(logic), true value, false value)
When logical is “false,” it will return “true value.” When logical is “true,” it will return “false value.”
Example: If a student scores less than 80 on both Science and Mathematics exams, or even on one subject, the status should be “Fail.”
Formula: IF(AND(Science>=80, Mathematics>=80), "Pass","Fail")
Using Drop-down and Radio button Fields in IF Formulas:
Example: Shipping should be $10 if an order is international, free if domestic.