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.

Relational and logical operators
Operator	Description
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 (SQL) 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
Example: Suppose you set up the following double IF statement:

IF( Is Fill Insul Reqd ? ,IF( Is Waterproof Reqd ? ,Area SF,0),0)

The answer to "Is Fill Insul Reqd?" determines what happens next.
- YES would then ask "Is Waterproof Reqd?". The reply to that question returns either the area or a value of zero.
- NO would do nothing further.
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.