Korean Job Discussion Forums

[nathanrutledge]

I did my speaking test last week, and I grade the kids on 4 things, giving them 3, 2, or 1 point in each category.

I can only give the students 10,9,8,7, or 6 points for their grade.

So, I've added up all my points, and I want to set up an "IF/THEN statement" on excel to recognize and print the right score for me.

Example if a student gets "12" then print 10", if they have 10,11, then print 9, etc....

Anyone know how to do this? I've written some long IF statements, where I tell it to print the score if it's true, and if it's false to check a new IF statement, but when it comes to the end, I don't know what to put for "false" (there should be no false answers by that point.

Thoughts?

[vDroop]

I use this for my work, should be fine if you replace some things.

=IF(H31>4.24, "A+",IF(H31>3.99, "A",IF(H31>3.74, "B",IF(H31>3.49, "C",IF(H31>3.25, "D",IF(H31>1, "F"))))))

Cell H31 has the score, then a grade A to F is assigned from that.
Replace A - F with your point system. And obviously replace the conditions.

[nathanrutledge]

Thanks.

I figured it out on my own right after I posted this, and came up with something similar.

IF(SUM(A3,A4,A5,A6)=12,"10",IF(10<(SUM(A3,A4,A5,A6),"9"......

Before I was doing 6<=sum<=8, and so on, and when i got to the end, I didn't have a false statement. But I realized that if I just left the last answer as my false statement, I'd get it.

So yeah, what you wrote is about what I ended up with.

Thanks for the input (pun intended).