Formula help - Sum results Pass or Fail
this one works for school based users
Subject order: Home Lang, Sec Add Lang, Life Orient, Math/Mlit, PHS/ACC/HIST, Bust/Life Sc, Geog/ Econ. use excel.
=IF(AND(D239,E229,F239,OR(G229,OR(OR(J229,L2 29,K229),OR(I229,M229),OR(N229,H229)))),"PASS ","FAIL")...
test with various marks according to the pass requirements. Hope this will be helpful
|