3 check boxes - all are check senior

[lezawang]

Hi
I have 3 checkboxes in a sheet. I liked them to cells k2,k3, and k4.
I created if statement, please see below. The only problem I have
when use check more than one boxes. My if function does not handle
this situation. I want to send a message saying "One box has to be selected at a time"
How can I do that? Thank you very much


=IF(K2=TRUE,"1st choice",IF(K3=TRUE,"2nd choice",IF(K4=TRUE, "3rd","3rd choice")))

 

[Roderick_E]

Why not use radio buttons in a group, this way the user CAN'T select more than one at a time.