I have a sheet containing two rows
first rows I have passing marks B1:H1
second row I have obtained marks B2:H2
I want to display "promoted" in result column
if a student fail in 2 subjects (if Passing marks < obtained marks) but
if he has total marks B2:H2 greater than 182 he should be promoted.
Bookmarks