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.