Forum Discussion
formula for multiple conditions
I have 6 columns representing 6 subjects 7th column is of Total marks of all the 6 subjects whereas the 8th column is of Result The Result column should display three outputs based on the following...
Try this formula
=IF(AND(C2=0,D2=0,E2=0,F2=0,G2=0,H2=0),"Absent",IF(AND(C2>35,D2>35,E2>35,F2>35,G2>35,H2>35),"Pass","Promoted"))