When using an IF function, if customers with overdue payments fall into only one category (90 days, 60 days, or 30 days), ____.
A) you should test the 90-day condition first
B) you should test the 60-day condition first
C) you should test the 30-day condition first
D) it doesn't matter which condition is tested first

Question

Quizplus · Accepted Answer

Since customers can only fall into one category (90 days, 60 days, or 30 days overdue), the order in which these conditions are tested does not affect the outcome. Each condition is mutually exclusive.

When Using an IF Function, If Customers with Overdue Payments