1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Excel Radio buttion help

Discussion in 'Windows & Other Software' started by area51_for_psx, 10 Jun 2010.

  1. area51_for_psx

    Wise Guy

    Joined: 22 May 2004

    Posts: 1,724

    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