Assign numerical points based on dropdown text values?

jacobjs

New Member
Joined
Mar 23, 2012
Messages
1
Hi!

I would like to create a point systems where I assign different points based on yes or no answers through a dropdown, i.e.

Question 1:
Yes = 2
No = 0

Question 2:
Yes = -1
No = 0

etc...

How can I do that?

Thanks in advance! :)
 

Sam_D_Ben

Active Member
Joined
Oct 17, 2012
Messages
381
You mean validating both the answers and points in drop-down list or just the points. There is something called "data validation" in excel. I guess it'll help you with your requirement.
 

Forum statistics

Threads
1,085,703
Messages
5,385,309
Members
401,938
Latest member
JustinTaster

Some videos you may like

This Week's Hot Topics

Top