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.