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

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))