Microsoft Office Tutorials and References

In Depth Information

**Review Questions**

REVIEW QUESTIONS

You will find these examples in the Excel Chapter 8 file:

1.
On the sheet Practice IF, I have a table of salespeople

s annual sales. Use an IF

statement to calculate commissions for annual total sales with the following

rates: $10,000 or less, commission is 5 percent and for anything over $10,000,

commission is 7 percent.

2.
On the same sheet and example, calculate using nested IF:

’

Sales

Commission

Below 5,000

2.0 percent

Between 5,000 and 15,000

3.0 percent

Between 15,000 and 25,000

3.5 percent

Above 25,000

4.0 percent

ANSWERS

1.

2.
This is a nested IF:

¼

IF(B6

<
¼

5000, B6*2%,

IF(B6

<
¼

15000, 5000*2%

þ

(B6

–

5000)*3%,

IF

(B6

<
¼

25000,

5000*2%

þ

10000*3%

þ

(B6

–

15000)*3.5%,

5000*2%

þ

10000*3%

þ

10000*3.5%

þ

(B6

–

25000)4%)))