contestada

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?

Respuesta :

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:

MrRoyal

Excel formulas are expressions used to perform computations.

The Excel formula to enter in cell I6 is = IF(G6 < 1, "A",IF(G6 < 30, "B","C"))

From the question, we have the following conditions

  • Values in cell G6 less than 1 have a rating of A
  • Values in cell G6 less than 30 have a rating of B
  • Otherwise, the rating is C

So, we have the following Excel conditions:

  • IF G6 < 1, then A
  • IF G6 < 30, then B
  • Else C

Hence, the formula is:

= IF(G6 < 1, "A",IF(G6 < 30, "B","C"))

Read more about Excel formulas at:

brainly.com/question/1285762

Otras preguntas

Q&A Education