Your question is unclear. If this doesn't solve your problem, it should at least give you the tools to do so. If you clarify, I can edit my answer based on your new information. I'm going to assume that <=50% is fail, >50% is pass, and your three conditions are summed.
So, breaking down your three conditions, you get:
- =IF(A2="no",0,0.5)
- =IF(B2="yes",0.15,0)
- =IF(C2="yes",0.35,0)
Because each of these formulas simply resolve to a number, you can add them together with SUM()
SUM(IF(A2="no",0,0.5),IF(B2="yes",0.15,0),IF(C2="yes",0.35,0)) will give just another number (0.35 in this case) which can be compared to your definition of passing (greater than 50%) and used in the logical test for one last IF().
The result is:
=IF(SUM(IF(A2="no",0,0.5),IF(B2="yes",0.15,0),IF(C2="yes",0.35,0))>0.5,"pass","fail")
In this case, I chose to use SUM() purely for readability purposes. You could have also just done
=IF(IF(A2="no",0,0.5)+IF(B2="yes",0.15,0)+IF(C2="yes",0.35,0)>0.5,"pass","fail")
but I think that's marginally harder to understand by inspection.