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.

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

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.

Instead of a SUM() function,

you can use the COUNTIF() function:

A 1) Yes 2) No 3) Yes 4) Yes 5) NoIn cell A6 put the formula: =COUNTIF(A1:A5,"Yes")

You should get the value 3

Would that work for you?

MIKE

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.

Ask Your Question

Weekly Poll

Would you be willing to go on a SpaceX trip around the moon?

Discuss in The Lounge

Poll History