Procedure:
Step 1 – Open Libre Office Cal work sheet Applications → Office → Libre Office calc
Step 2 – Enter the data in the given cells
Step 3 – Enter the following formula in cell D2 = IF(C2 < 30, “FAIL”, IF(C2 < 40, “D+”, IF(C2 < 50, “C”, IF(C2<60, “C+”, IF(C2 < 70, “B”, IF (C2 < 80, “B+”, IF(C2 < 90, “A”, IF(C2 < 100, “A+”))))))))
Step 4 – Drag the formula to D9
Output: