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

Report •


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

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

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
✔ Best Answer
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 3

Would that work for you?

MIKE

http://www.skeptic.com/


Report •

Related Solutions

#4
November 11, 2014 at 07:12:45
Perhaps Mike's solution will work for you, but if not you'll need to supply more details.

Keep in mind that we can't see your spreadsheet from where we're sitting so you need to be specific when explaining what you are trying to do. Cells references and the formulas that you are using would be helpful.

Without more details, I'm having trouble understanding what this means:

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.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •


Ask Question