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%)))
 
Search JabSto ::




Custom Search