The IF function is one of the most popular functions in Calconic, and it allows you to make logical comparisons between a value and what you expect. You can write conditional formulas using our Basic Formula Editor or Rich Formula Editor. This article explains how to write confitional (IF) formulas using the Rich Formula Editor. If you want to understand conditional formula syntax and write formulas using Basic Formula Editor click here.
AND (&) can be used in an IF function when there are more than one simultaneous conditions. For example:
IF #2 >= 1 AND #3 == 0 THEN (#4+12) ELSE (#5)
((#2 >= 1 & #3 == 0) ? (#4+12) : (#5))
OR (|) can be used in an IF function if there are multiple conditions and the user wants to use a formula if either of them meet the requirements, which should be written in THAN. If none of the conditions are met, the formula in ELSE will be used.
== - Both numbers or inputs are equal.
!= - The numbers or inputs are unequal.
> - The number or input is greater than the number it is being compared to.
< - The number or input is smaller than the number it is being compared to.
>= - The number or input is greater or equals to the number it is being compared to.
<= - The number or input is smaller or equals to the number it is being compared to.