# Solved Dropdown yes/no = 1/0

November 10, 2014 at 22:34:40
Specs: Microsoft Excel 97 - 2003
 I know how to create a dropdown list but I want to know how to create a rule on each option of the dropdown. Eg, it will be a yes/no dropdown, if I choose 'yes' it should be = to '1' and if I choose 'no' it should be = to '0'. Please help.

See More: Dropdown yes/no = 1/0

#1
November 11, 2014 at 03:55:15
 If you want the 1 & 0 to appear in the same cell as the drop down, you will need to use a macro. If that is what you want, and if using a macro is OK, let me know.If Yes/No - 1/0 is just an example, and there are actually more choices/changes, we need to know that also.message edited by DerbyDad03

Report •

#2
November 11, 2014 at 04:41:16
 I have a sum which will calculate the 1 or 0 with another amount but I don't want the 1 or 0 to show. I want to be able to choose yes or no from the dropdown list which will then automatically still calculate my sum without it giving an error in my formula.

Report •

#3
November 11, 2014 at 06:54:39
 Instead of a SUM() function, you can use the COUNTIF() function:``` A 1) Yes 2) No 3) Yes 4) Yes 5) No ```In cell A6 put the formula: =COUNTIF(A1:A5,"Yes")You should get the value 3Would that work for you?MIKEhttp://www.skeptic.com/