Solved

Jason Wants to Display the Text "Poor" If the Value

Question 92

Multiple Choice

Jason wants to display the text "Poor" if the value in cell A3 is less than 25.If the value in cell A3 is less than 50, Jason wants to display "Average"; otherwise, he wants to display "Good".Which of the following formulas should he use?


A) '=IF(A3 < 25, "Poor", IF(A3 < 50, "Average","Good") )
B) =IF(A3 < 25, "Poor", "Average", "Good")
C) =IF(A3 < 25, "Poor") , IF(A3 < 50, "Average")
D) IF(A3 > 50, "Good", =IF(A3 < 25, "Poor", "Good")

Correct Answer:

verifed

Verified

Unlock this answer now
Get Access to more Verified Answers free of charge

Related Questions