((EXCEL)) I am having a hard time figuring out the correct formula to this question. If anyone could help out, I'd really appreciate it!

1. 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:
   1. 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.
   2. 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.
   3. Display a rating of "C" if the conditions are false.
   4. Use the Fill Handle to fill the range I7:I15 with the formula in cell I6, filling the range without formatting.