Only show positive answers

[Losguapos1]

Hello,

I am teacher and i would like to create a grader where all you do is input the number of questions and it will calculate the score automatically for you.

I have started something but not sure if what i want can be done. I am looking for a way when you input the number of questions then column B will only count down to that. and then column D will only show scores 0% and higher not the negatives.

Basically what i'm looking for is a way that i can use this for a test with any give calculations. and if there are no number of questions entered then the sheet will remain blank.

Any and all help would be greatly appreciated.

Los

[Fotis1991]

Hi

Perhaps

Please Login or Register  to view this content.

[Losguapos1]

that works perfect, now is there any way i can make the number wrong column only go up the number of questions on the test?

[TexasKersh]

Grader.xlsxHi Los

Try the enclosed :-)

[Losguapos1]

awesome thanks

[TexasKersh]

Your are welcome.

Can you mark the thread closed if you are happy with the solution. If you are having a good day and like the enclosed, feel free to add rep at the bottom left of the post.

Thanks. Peace