+ Reply to Thread
Results 1 to 1 of 1

Radio buttons - Excel 2010

  1. #1
    Registered User
    Join Date
    MS-Off Ver
    Excel 2010

    Radio buttons - Excel 2010


    I am designing an audit checklist whereby I want each line to have four options using radio buttons (Fail, Poor, Compentent, Excellent, N/A)

    I know how to group each four buttons into an exclusive group but I want to assign a value to each of the options. (fail=0, poor=1, compentent=2, Excellent=3) I then need the scoring to be in a hidden column which can be added together at the end to work out total score.

    I also need a formula to add to a totals box at the bottom that if N/A is selected the whole line is taken out of the total scoring.

    How do I do this? (I am a basic Excel user!)

    Many Thanks
    Last edited by terri.van-niekerk; 01-11-2013 at 06:51 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1