IFTHEN Stuff

[Excel Ranger]

I'm formatting a quick ref grade tracking sheet for my PocketPC. The part that I'm having trouble with is the last cell in a column. What I am trying to do is have a letter grade represent a range of percentile grades (i.e. > 89.9 = "A", > 79.9 = "B", ..."F".).

Subtotal 0.0 (=SUM(B2:B13))
Div by 250 0.0 (=B14/250) (MAX POSSIBLE FOR COURSE IS 250)
x 100 0.0 (=B15*100)
Grade ??? If > 89.9, "A"…

The target cell for the letter grade is B17. I had this formula worked out before, but I had inadvertantly deleted the file that it was in. OOPS!

Thank you.

 

[fairwinds]

Hi,

Try something like:

=LOOKUP(A1,{0,10,20,30,40},{"E","D","C","B","A"})

Needs to be adjusted to meet your values.

 

[Andrew Poulsom]

Something like this?

=LOOKUP(B16,{0;50;60;70;80;90},{"F";"E";"D";"C";"B";"A"})

 

[Excel Ranger]

Tweaked it a bit. American schools don't use the "E" grade.

=LOOKUP(B16,{50;60;70;80;90},{"F";"D";"C";"B";"A"})

Thank you very much. It looks easier than I thought.

 

[Scott Huish]

Unless 50 is the minimum grade, you may want to change that to 0

 

[Excel Ranger]

I threw in some values for a total less than 50 and it showed up as "F", so it works for me.