beautypg.com

HP 17bII+ User Manual

Page 175

background image

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

VALUEFIRST+1

÷ FIRST. If FIRST=0, then VALUEFIRST.

„     
Means:

If

A or B, but not both, equals 0, then TW x (A + B).

Otherwise,

T = W x A x B. In other words,

When

A=0 and B≠0, TW x B.

When

A≠0 and B=0, TW x A

When

A=0 and B=0, T=0.

When

A≠0 and B≠0, TW 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?