DropBox Calulation

1. 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

2. Re: DropBox Calulation

hI brandnicks
Welcome to the forum

3. 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

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