Using the IF Function to Determine a Grade
| Score | Grade |
|---|---|
| 0-39 | F |
| 40-49 | D |
| 50-59 | C |
| 60-69 | B |
| 70-100 | A |
Solution: =IF(A1<=39, "F", IF(A1<=49, "D", IF(A1<=59, "C", IF(A1<=69, "B", "A"))))
Using the IF Function to Determine a Discount
| Total Sales | Discount |
|---|---|
| 0-100 | 0% |
| 101-200 | 5% |
| 201-300 | 10% |
| 301-400 | 15% |
| 401+ | 20% |
Solution: =IF(A1<=100, 0, IF(A1<=200, A1*0.05, IF(A1<=300, A1*0.10, IF(A1<=400, A1*0.15, A1*0.20))))
Using the IF Function to Determine Shipping Cost
| Weight | Shipping Cost |
|---|---|
| 0-1kg | $5 |
| 1.1-2kg | $10 |
| 2.1-3kg | $15 |
| 3.1kg+ | $20 |
Solution: =IF(A1<=1, 5, IF(A1<=2, 10, IF(A1<=3, 15, 20)))
Using the IF Function to Determine a Bonus
| Years of Service | Bonus |
|---|---|
| 0-2 | $0 |
| 3-5 | $500 |
| 6-10 | $1000 |
| 11+ | $1500 |
Solution: =IF(A1<=2, 0, IF(A1<=5, 500, IF(A1<=10, 1000, 1500)))
