Looking for the right formula.

[MaverickCS5]

Hi guys,

Looking for the right formula that will let me enter in a text criteria and then subtract a certain number from the value 100, based on what text is matched.

i.e score is currently 100 but if No is entered in various cells, then the value is reduced by 20 each time it is. 

How would I go about this?

[#2]

something like
=IF( c2="no", A2-20, A2)
or if you want to do multiple
=A2-COUNTIF(C2:F2, "no")
note the cells and ranges are made up as I don't understand which cells you are looking at to check if they are "no" and which cell or cells are supposed to have the value in them