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...
=LET(g,C2:H2,IF(COUNTIF(g,">=35")=6,"Promoted",IF(COUNTIF(g,"<35")>0,"Passed",IF(SUM(g)=0,"Absent",""))))