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?

​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?  Read More

​