Add points based on YES or NO answer

**alw2** · 01-03-2011, 10:37 PM

Can someone please refresh me on how to achieve the following? I am trying to allocate points to people, based on a yes or no answer.
If the name had YES next to it, they person would get 2 points. If NO, negative two points. At the end, I want to add up all of the points to get a final score. Some of the entries are allowed to be blank, which would result in zero points.
There are 40 names.
What formulas could I use to get this to work?

Thanks!

**6StringJazzer** · 01-04-2011, 12:05 AM

For this type of question, it is always better to attach your workbook, or at least one that has the same data organization as your workbook.

If I assume that your YES/NO answers are in column B, and the same row as your points, one formula to give points in row 2 would be

=IF(B2="",0,IF(B2="YES",2,IF(B2="NO",-2)))

If B2 is anything other than blank, YES, or NO, the result is FALSE.

**NickyC** · 01-04-2011, 12:10 AM

Hi
is a formula like this what you're after (where cell B2 contains values yes, no etc)?
=IF(B2="yes",2,IF(B2="no",-2,0))

**DonkeyOte** · 01-04-2011, 03:33 AM

It's not clear if you want to store points adjacent or in summary, for the latter:

Please Login or Register  to view this content.

**DonkeyOte** · 01-04-2011, 03:35 AM

@alw2, please note duplicate threads are not permitted per Forum Rules.

Normally duplicates would be closed - given your post count and the fact you have separate replies on each thread I will on this occasion merge the two.