Results 1 to 2 of 2

Thread: Assign numerical points based on dropdown text values?
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Mar 2012
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Assign numerical points based on dropdown text values?

    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!

  2. #2
    Board Regular Sam_D_Ben's Avatar
    Join Date
    Oct 2012
    Location
    New Jersey, USA
    Posts
    371
    Post Thanks / Like
    Mentioned
    4 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Assign numerical points based on dropdown text values?

    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.
    Sam_D_Ben

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •