HP 17bII+ User Manual
Page 175
12: The Equation Solver 175
File name : English-M02-1-040308(Print).doc Print data : 2004/3/9
Examples of Conditional Equations.
=
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.
Means:
If
FIRST is not equal to 0, then
VALUE=FIRST+1
÷ FIRST. If FIRST=0, then VALUE=FIRST.
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?