Excel 2007
Reg: Marksheet formula
Columns B to J are in numerical format containing marks
obtained.
Helper Cell K1 contains 50 in numerical format, minimum
required marks for a "Pass".
Columns B,C & D are category 1 and student should pass at
least 2 subjects (out of 3)
Columns...