Explain how to calculate the result in 8th column, a student is declared ‘PASS’ if he gets 40 or more in each subject or the average of marks is 50 or more, otherwise result is ‘FAIL’.(Excel-2007)

A worksheet contains Name, Marks in three subjects namely M1, M2, M3 in rows 1 to 35.The first row contains the headings and the other contains the data. Explain how to calculate the result in 8^th column, a student is declared ‘PASS’ if he gets 40 or more in each subject or the average of marks is 50 or more, otherwise result is ‘FAIL’.

To compute result in column H. (assuming that marks are entered in columns B, C and D)

Enter the formula,

=IF (OR(AND(B2>=40,C2>=40,D2>=40),AVERAGE(B2,C2,D2)>=50),"PASS","FAIL")

in cell H2 and then press enter key, using the fill handle of cell H2, copy the formula to cells H3 :H35 by dragging the fill handle up to cell H35.

Related Posts by Categories