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! :)
 

Some videos you may like

Excel Facts

Test for Multiple Conditions in IF?
Use AND(test, test, test, test) or OR(test, test, test, ...) as the logical_test argument of IF.

Sam_D_Ben

Active Member
Joined
Oct 17, 2012
Messages
379
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,102,736
Messages
5,488,566
Members
407,646
Latest member
utl1095

This Week's Hot Topics

  • Timer in VBA - Stop, Start, Pause and Reset
    [CODE=vba][/CODE] Option Explicit Dim CmdStop As Boolean Dim Paused As Boolean Dim Start Dim TimerValue As Date Dim pausedTime As Date Sub...
  • how to updates multiple rows in muliselect listbox
    Hello everyone. I need help with below code. code is only chaning 1st row in mulitiselect list box. i know issue with code...
  • Delete Row from Table
    I am trying to delete a row from a table using VBA using a named range to find what I need to delete. My Range is finding the right cell. In the...
  • Assigning to a variable
    I have a for each block where I want to assign the value in column 5 of the found row to the variable Serv. [CODE=vba] For Each ws In...
  • Way to verify information
    Hi All, I don't know what to call this formula, and therefore can't search. I have a spreadsheet with information I want to reference...
  • Active Cell Address – Inactive Sheet
    How to use VBA to get the cell address of the active cell in an inactive worksheet and then place that cell address in a location on the current...
Top