Filter
Top Products
174 12: The Equation Solver
File name : 17BII-Plus-Manual-E-PRINT-030709 Print data : 2003/7/11
Conditional Expressions with IF
Equations can include conditional expressions using the function IF. The
syntax of the IF function is:
IF
L
conditional expression
I
algebraic expression
I
algebraic expression
T
*
For example, the solver accepts the equation:
JE<4F8;GLF19HF[%(((I&($
B
F19HFI&(#
B
F19HFT"
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.
Operator Keys
＞
＜
＝
≥
≤
≠
³
(ALPHA menu)
´
(ALPHA menu)
=
³
=
´
=
´
³
*
A conditional expression that contains within it an algebraic expression might
cause the error
;<O19;A
HY41:;E<
. If this happens, insert a
)
before the
left parenthesis starting the algebraic expression. For example, change
;GLL1)$TD.Z#$I&&&
to
;GL)L1)$TD.Z#$I&&&
.
then or else