Check if the percentage is higher than or equal to 80%. If true, display 'EXCELLENT'.

Question

ScanSolve AI Tutor · Accepted Answer

To display the comments 'EXCELLENT', 'PASSED', or 'FAILED' based on the 'TEST 1 PERCENTAGE', you can use a nested IF function in a spreadsheet program like Excel.

Assuming the 'TEST 1 PERCENTAGE' for the first student is in cell D2:

Check if the percentage is higher than or equal to 80%.
If true, display 'EXCELLENT'.
$\text{IF(D2} \ge \text{80, "EXCELLENT", ...)}$
If the percentage is not 'EXCELLENT' (i.e., less than 80%), check if it is higher than 60%.
If true, display 'PASSED'.
$\text{IF(D2} > \text{60, "PASSED", ...)}$
If neither of the above conditions is met (i.e., the percentage is 60% or lower), display 'FAILED'.
$\text{"FAILED"}$
Combining these steps into a single nested IF function:
$\boxed{\text{=IF(D2}\ge\text{80,"EXCELLENT",IF(D2>60,"PASSED","FAILED"))}}$

Check if the percentage is higher than or equal to 80%. If true, display 'EXCELLENT'.

Step-by-step solution

Check if the percentage is higher than or equal to 80%.

If the percentage is not 'EXCELLENT' (i.e., less than 80%), check if it is higher than 60%.

If neither of the above conditions is met (i.e., the percentage is 60% or lower), display 'FAILED'.

Still stuck on this one?

More Mathematics Questions