I'm not clear on the layout- if collumn b contains a Yes or No, and b 5 is the result you need this:
=B3-((COUNTIF(B4:B6,"No")*25))

If A2:A3 contains not just the yes or no but the whole text, then you need this:
=B3-((COUNTIF(B4:B6,"*No*")*25))

---
frmsrcurl: http://msgroups.net/microsoft.public...ement-in-excel