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 > 50, "Good", =IF(A3 < 25, "Poor", "Good")
B) =IF(A3 < 25, "Poor") , IF(A3 < 50, "Average")
C) =IF(A3 < 25, "Poor", "Average", "Good")
D. =IF(A3 < 25, "Poor", IF(A3 < 50, "Average","Good") )
Correct Answer:
Verified
Q11: What is the correct formula to insert
Q29: Which of the following formulas can you
Q34: Sheila wants to extract the hour from
Q423: Patrick is editing a worksheet with many
Q425: You can use the Excel equation tools
Q430: Liam needs to count the cells in
Q433: Jose inserts the formula =DATE(2021, 2, 15)
Q440: To insert only the current date in
Q441: Cell A5 contains the number 24.7835.In another
Q454: Which of the following options should you
Unlock this Answer For Free Now!
View this answer and more for free by performing one of the following actions
Scan the QR code to install the App and get 2 free unlocks
Unlock quizzes for free by uploading documents