Procedure:
Step 1 – Open LibreOffice Calc worksheet Application → Office → LibreOffice calc
Step 2 – Enter the details in the form of a Table
Step 3 – Enter the following formula in F2 and drag with ll up to F6 = IF(OR(C2>=5, D2>=50, E2<=5), ‘‘Qualied”, “Not Qualied”)
Output:
Chest No. |
Result |
203 |
Qualified |
2016 |
Qualified |
275 |
Qualified |
304 |
Not Qualified |
361 |
Qualified |