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...
Here is another formula that seems to do the job:
=IFS(MIN(D7:I7)>=35,"Pass",SUM(D7:I7)=0,"Absent",MIN(D7:I7)<35,"Promoted")
Cool thing about Excel - there are all kinds of ways to do things!
@merryashish143merryashish143