Rightclick on the icon bar. Select Forms
Then Insert 3 Checkboxes. Rightclick on one of the boxes and select
cell link. Select B5. Repeat with the other Checkboxes, and select
links to B6, B7.

In B2 insert this formula: =CHOOSE(1+B5*1+B6*2+B7*3,"",3,0,"-")
If there is a risk that Yes and No is selected, add ,"","",""

Ola Sandström


See pictu
http://www.excelforum.com/attachment...tid=3487&stc=1


+-------------------------------------------------------------------+
|Filename: Clipboard01.jpg |
|Download: http://www.excelforum.com/attachment.php?postid=3487 |
+-------------------------------------------------------------------+

--
olasa
------------------------------------------------------------------------
olasa's Profile: http://www.excelforum.com/member.php...o&userid=17760
View this thread: http://www.excelforum.com/showthread...hreadid=378652