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...
merryashish143 I believe this formula does exactly what you ask for, though I'm not sure what want to return if not all 6 marks are blank. This one will return "Promoted" even when you only enter one mark.
=IF(COUNT(C2:H2),IF(SUM(--(C2:H2>={35,35,35,35,35,35}))=6,"Pass",IF(SUM(--(C2:H2<{35,35,35,35,35,35}))>0,"Promoted")),"Absent")