((EXCEL)) I am having a hard time figuring out the correct formula to this question....
70.2K
Verified Solution
Link Copied!
Question
Accounting
((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!
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:
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.
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.
Display a rating of "C" if the conditions are false.
Use the Fill Handle to fill the range I7:I15 with the formula in cell I6, filling the range without formatting.
Answer & Explanation
Solved by verified expert
Get Answers to Unlimited Questions
Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!
Membership Benefits:
Unlimited Question Access with detailed Answers
Zin AI - 3 Million Words
10 Dall-E 3 Images
20 Plot Generations
Conversation with Dialogue Memory
No Ads, Ever!
Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
