Radio Buttons
Add a frame from the forms toolbar, than add the 3 buttons into that.
Link the buttons (Format controlControl) to the same cell, and the formulae
become
B1: =(H1=1)*10
B2: =(H1=2)*10
B3: =(H1=3)*22
--
HTH
Bob
(there's no email, no snail mail, but somewhere should be gmail in my addy)
"Saxman" wrote in message
...
Would it be possible to add 3 radio buttons namely C, D, CD in cells
A1,A2,A3 as
part of a group (so only one choice can be selected) and award points in
adjacent
cells B1:B3?
C gets 10 points.
D = 10
CD = 22
TIA.
--
|