If function

IF returns the appropriate result based on whether certain conditions are satisfied. The function must contain a condition (or equation) that produces a true or false answer and a result for each answer. Enter a separator (shown as a comma below) after each condition and answer.

Syntax	IF (condition, true, false)
Examples	IF (Depth LE 6, 6, Depth) IF (Using forms?,Width + 24, Width) IF (Using adhesive?,50,80) * (Area SF /32)/35/50

The condition may include any of the relational and logical operators below.

GT or >	Greater than
LT or <	Less than
EQ or =	Equal to
GE or >=	Greater than or equal to
LE or <=	Less than or equal to
NE or <>	Not equal to
AND	Returns the true result only if both conditions are satisfied. Example
OR	Returns the true result if either condition is satisfied. Example
NOT	Modifies part of an equation to reverse its meaning. Example

Tips:

To obtain a result that satisfies a condition with more than two parts, use AND combined with OR. Remember, Sage Estimating calculates a function from left to right working outward from the innermost set of parentheses.
You can set up a double IF statement that asks a second question based on the reply to the first question. To do this, insert a second IF statement in place of the true or false in the first IF statement. Example
When an IF function includes GT, LT, EQ, GE, LE, or NE, it ignores differences beyond the 14th decimal place of the numbers being compared.