Conditional Expressions with IF

Equations can include conditional expressions using the function IF. The syntax of the IF function is:

IFconditional expression algebraic expression algebraic expression

 

 

 

 

then

or

else

For example, the solver accepts the equation:

    

According to this equation, if SALES is greater than 3000, then the BONUS equals .02 ⋅ SALES; otherwise (“or else”), BONUS equals

.01 ⋅ SALES.

Logical Operators. Four logical operators can be used in conditional expressions: AND, OR, XOR, and NOT.

Relational Operators. Six relational operators are available for conditional expressions.

OperatorKeys

＞(ALPHA menu)

＜(ALPHA menu)

＝=

≥=

≤=

≠

174 12: The Equation Solver

File name : English-M02-1-040308(Print).doc Print data : 2004/3/9