# IFTHEN Stuff

#### Excel Ranger

##### Board Regular
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.

### Excel Facts

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},\$Z\$1:\$Z\$99,\$Y\$1:\$Y\$99),2,False) to lookup Y values to left of Z values.

#### fairwinds

##### MrExcel MVP
Hi,

Try something like:

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

#### Andrew Poulsom

##### MrExcel MVP
Something like this?

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

#### Excel Ranger

##### Board Regular
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

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

#### Excel Ranger

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

Replies
11
Views
728
Replies
1
Views
828