Filter
Top Products
12: The Equation Solver 175
File name : 17BII-Plus-Manual-E-PRINT-030709 Print data : 2003/7/11
Examples of Conditional Equations.
!
J
=
;G
L1[-
1<A
1Z8#.I$B1D'I%B1)#(T)7
Means: If A is greater than 7 and is less than or equal to 15, then
B＝ 2 x A ÷ 6＋C. Otherwise, B＝3 x A＋10＋C.
!
O194H
8
G;2F:);GL<E:LG;2F:8(TI#DG;2F:I(T
Means: If FIRST is not equal to 0, then
VALUE＝FIRST＋1 ÷ FIRST. If FIRST＝0, then VALUE＝FIRST.
!
:
8
C"B;GL18(
XE2
J8(I1)JI1]JT
Means: If A or B, but not both, equals 0, then T＝W x (A + B).
Otherwise, T = W x A x B. In other words,
When A＝0 and B≠0, T＝W x B.
When A≠0 and B＝0, T＝W x A
When A＝0 and B＝0, T＝0.
When A≠0 and B≠0, T＝W x A x B.
Example: Nested IF Functions. An IF function can be used as the
argument of another IF function. This is called nesting. Suppose a
corporation uses a rating system to determine salary. Employees are
rated on a scale from 1 through 3, and are given the following annual
percent raise based on their rating:
Rating Percent Salary Increase
1
2
3
3%
6%
10%
The Solver equation to calculate an employee’s new salary is based on
his or her rating and old salary. What would be the new annual salary
for an employee with a rating of 2 who currently earns $27,500
annually?