View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] maepakaydee@gmail.com is offline
external usenet poster
 
Posts: 1
Default 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