Yes No field in Excel

[cdenski]

I have an Excel spreadsheet. I have a column where I want the user to be able to pick the value Yes or No, instead of typing it each time. I had tried the =Choose(1;"Yes)(2;"NO") but this isn't working.

Any tips?

 

[paliman]

How about a validation list?
Go to DATA-VALIDATION. In the 1st window choose "list" and in the source field type

Yes,No

Then you will have a pulldown menu with these 2 options

Another option could be adding an extra column and using an IF function to get "Yes" when you type a 1 and "No" when you type a "0".

 

[cdenski]

Thanks, works, except in the source you must have a semi-colon between Yes and No to be able to pick between them

 

[Sourdust]

Must be a different version of Excel because I need a comma not a semi colon to get the option of Yes or No. A semi colon just allows Yes; No