Complete the code to return "Pass" if the score is 50 or more, otherwise "Fail".
=IFS(A1 >= 50, [1], TRUE, "Fail")
The IFS function checks conditions in order. If the score in A1 is 50 or more, it returns "Pass".
Complete the code to return "Excellent" if score is 90 or more, "Good" if 70 or more, otherwise "Needs Improvement".
=IFS(A1 >= 90, "Excellent", A1 >= 70, [1], TRUE, "Needs Improvement")
The second condition returns "Good" if the score is 70 or more but less than 90.
Fix the error in the formula to return "Low" if value is less than 50, "Medium" if less than 80, else "High".
=IFS(A1 < 50, "Low", A1 < 80, [1], TRUE, "High")
The second condition's result should be "Medium" for values less than 80 but not less than 50.
Fill both blanks to create a formula that returns "Fail" if score is below 50, "Pass" if below 75, else "Excellent".
=IFS(A1 < [1], "Fail", A1 < [2], "Pass", TRUE, "Excellent")
The first blank is 50 for failing scores below 50. The second blank is 75 for passing scores below 75.
Fill all three blanks to create a formula that returns "Poor" if score is below 40, "Average" if below 70, "Good" if below 90, else "Excellent".
=IFS(A1 < [1], "Poor", A1 < [2], "Average", A1 < [3], "Good", TRUE, "Excellent")
The blanks represent the upper limits for each category: 40 for Poor, 70 for Average, and 90 for Good.