Assign numerical points based on dropdown text values?

jacobjs

New Member
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
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.
 

Some videos you may like

This Week's Hot Topics

Top