To calculate result as “Fail” when percentage of marks (PER) is less than 35, otherwise “Pass”.
Explain the steps to perform the following for the worksheet:
(i) To calculate result as “Fail” when percentage of marks(PER) is less than 35 ,otherwise “Pass”.
To compute result in column D,
Enter the formula,
=IF(C2<35,”FAIL”,”PASS”) in cell D2 and then press enter key,
using the fill handle of cell D2, copy the formula to cells D3 :D11, by dragging the fill handle up to cell D11.
ii) To calculate result as follows:
Percentage | Result |
<35 | Fail |
>=35 and <45 | Pass class |
>=45 and <60 | Scond calss |
>=60 and <75 | First class |
>75 | Distinction |
To compute result in column D.
Enter the formula,
=IF(C2>=75,”DISTINCTION”,IF(C2>=60,”FIRST CLASS ”,IF(C2>=45 , “SECOND CLASS”,IF(C2>=35 “PASS CALSS”,”FAIL”))))
in cell D2 and then press enter key, using the fill handle of cell D2, copy the formula to cells D3 :D11, by dragging the fill handle up to cell D11.
0 comments:
Post a Comment