# 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

How to change case of text in Excel?
Use =UPPER() for upper case, =LOWER() for lower case, and =PROPER() for proper case. PROPER won't capitalize second c in Mccartney

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

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

1,164,054
Messages
5,835,153
Members
430,342
Latest member
Sailingexcel

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back