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...
As variant
=LET( s, SORT(C2:H2,,,1), IF( SUM(s), IF( MIN(s) > 35, "Pass", "Promoted" ), "Absent" ) )