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." 
 
Formula: IF(subtotal<20,5,0)
 
calc01new.png
 
Using IF with AND, OR, and NOT Functions:
 
AND Function
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.”

OR Function
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.

NOT Function
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")
 
calc03new1.png
 
Using Drop-down and Radio button Fields in IF Formulas:
Example: Shipping should be $10 if an order is international, free if domestic.  
 
Formula: IF(country="U.S.",0,10)
 
calc02new.png
Was this article helpful?
0 out of 0 found this helpful

Comments

0 comments

Please sign in to leave a comment.