Examples of Conditional Equations.

„ =    

Means: If A is greater than 7 and is less than or equal to 15, then B2 x A 6C. Otherwise, B3 x A10C.

„  

Means: If FIRST is not equal to 0, then

VALUEFIRST1 FIRST. If FIRST0, 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 A0 and B0, TW x B. When A0 and B0, TW x A When A0 and B0, T0.

When A0 and B0, 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

13%

26%

310%

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?

12: The Equation Solver 175

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

Page 175
Image 175
HP 17bII manual Rating, Examples of Conditional Equations, VALUE=FIRST+1 ⎟ FIRST. If FIRST=0, then VALUE=FIRST