Question

PLEASE HELP! ON TIMER!! 5. Brett assigns each client a rating of A, B, or C depending on the number of days an invoice is overdue. Display this information using a nested IF function as follows: a. In cell I6, insert a formula using an IF function to test whether the days overdue (cell G6) are less than 1 and displays a rating of "A" if the condition is true. b. The next condition uses another IF function to test whether the days overdue (cell G6) are less than 30 and displays a rating of "B" if the condition is true. c. Display a rating of "C" if the conditions are false. Whats the cunction?

Answer 1

Answer:

b.The next condition uses another IF function to test whether the days overdue (cell G6) are less than 30 and displays a rating of "B" if the condition is true.

Hope this helps....

Explanation: