Excel Radio buttion help

Associate
Joined
22 May 2004
Posts
1,783
Location
N.Ireland
Hi guys. Have an excel doc for work that needs edited. It has radio buttons for questions and I need to add another 6 questions.


The radio buttions are for "Yes" , "No" or "NA". But when adding a new button it puts in a number in the cell when you have the buttion pressed. How do I change it so it will put in "True" in the buttons that are pressed and "False" in the other button cells that arnt pressed as an IF statement is at the buttom for counting how many yes and no's there is. And it is set up to count true and falses.

I hope this makes some sort of sense :D

Any help would be great, I have the file here if anyone needs to see it. As the guy that set it up before is off work at the moment
 
Back
Top Bottom