View Single Post
  #15   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] sabirbarijo@gmail.com is offline
external usenet poster
 
Posts: 1
Default Need (Excel) formula to make Mark sheet with Automatic Grading

SUM(C4:G4)
H4/500*100
IF(I4=68,"pass","Fail")
IF(I690,"A",IF(I680,"B",IF(I670,"C","F")))