checkbox formula (2000)

Topic

New Reply

Hello,

I was wondering if there is a way to have a formula or if statement for a checkbox. Basically, I want the user to only be able to select one box (see attached spreadsheet) at a time. The user can get the option of selecting one but not the other. Any help would be great.

Reply | Quote

Replies

without having looked at the spreadsheet, why not use radio buttons in lieu of checkboxes.

Reply | Quote

You could use option buttons (radio buttons) instead of check boxes. This is more in line with general use in Windows – check boxes are for mutually independent choices, and option buttons for mutually exclusive choices.

A group of radio buttons shares the same linked cell; the value of this cell will be the index of the selected radio button – 1 if the first one is selected, 2 if the second one is selected, etc. You can use this index in your formula.

Reply | Quote

Thank you both notbrl and Hans. This is exactly what I need it to use instead of the check boxes.

Reply | Quote