A local police office wants to create a rule that if an officer pulls over a person for exceeding the speed limit by at least five miles per hour or if that person has two or more speeding violations on record, the officer will fine the speeder the higher of $200 or $50 for each mile over the speed limit. Otherwise, the fine is $45. The speed limit is entered in cell B5, the person's speed is entered in cell B10, and the person's number of previous tickets is entered in cell B11. What function derives the correct answer?
a. =IF(OR(B10-B5>=5, B11>=2), MAX(200, (B10-B5)*50), 45)
b. =IF(OR(B10>B5, B11>=2), MAX(200, 50), 45)
c. =IF(AND(B10-B5>=5, B11<2), MAX(200, (B10-B5)*50), 45)
d. =IF(AND(B10>B5, B11>=2), 200, 45)
Answer: a. =IF(OR(B10-B5>=5, B11>=2), MAX(200, (B10-B5)*50), 45)
If the answers is incorrect or not given, you can answer the above question in the comment box. If the answers is incorrect or not given, you can answer the above question in the comment box.