+ Reply to Thread
Results 1 to 3 of 3

DropBox Calulation

  1. #1
    Registered User
    Join Date
    12-01-2011
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    2

    DropBox Calulation

    Hope you can help

    I have created worksheet with a rows of questions and each question uses a dropbox in which the person can choose to ther answer either with a YES, NO , N/A

    Once the person answers the question the data is then placed in another cell via LINKEDCELL. Once the data is placed in the cell i use this formula to calulate the score based on thier answer.

    Please Login or Register  to view this content.
    The score are as follows

    YES ranges from 1 - 3
    NO = 0
    N/A = 0

    My problem is how can i obtain the percentage score correctly

    What I did was to sum the score and then calulated the percenage based on difference between the score of YES on the total possible score. however that doesn't work because the person could choose N/A on few of the questions and that would go against them.

    So i tired to do a COUNTIF on the N/A and minus it from the total possible score, however that does work because i am only minusing the value of 1 per N/A and the YES and range from 1 - 3 depending on the question.

    Please help with another way to calulate the percentage of the score based on the total score
    Attached Files Attached Files
    Last edited by brandnicks; 12-01-2011 at 10:19 AM. Reason: Add attachment

  2. #2
    Forum Expert pike's Avatar
    Join Date
    12-11-2005
    Location
    Alstonville, Australia
    MS-Off Ver
    2016
    Posts
    5,327

    Re: DropBox Calulation

    hI brandnicks
    Welcome to the forum
    Dont really follow but.....=IF(G15=Financial!G$3,Financial!I$2*3, IF(G15=Financial!G$2,Financial!I$3*0,-Financial!I$2*3))
    If the solution helped please donate to RSPCA

    Site worth visiting: Rabbitohs

  3. #3
    Registered User
    Join Date
    12-01-2011
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: DropBox Calulation

    Thanks Sorry for the confusion, lets only use worksheet Clinical Protocol for now and I will duplicate on the other sheets once I get the sheet fixed

    If I use the code below the following will when
    Please Login or Register  to view this content.
    If Person chooses YES then multiple by 3 If the person chooses NO then multiple by 0 If they choose Blank or N/A minus by 3

    I am lost now how can now calculate the total score YES vs No to get a percentage excluding the N/A

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Bookmarks

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