#### AR1Redneck

Thread Starter

- Joined
- Dec 13, 2002

- Messages
- 206

OK i have a spreadsheet with all the grades on it, with all of them weighteed properly. The percentaage comes out perfect. What i am looking to do is, under the percentage, put the letter grade. For example, A, A-, B+, B, B-, and etc... OK i have the intervals that the percentage has to be in order to be a A or B and so on, but how can i formulate that into a formula so that when i put the grades in, i can get the letter grade as well as the percentage.

I have the formula for the percentage all complete, just need the one for the letter grade.

I saw somewhere there is a formula that contains an interval or something that if i say C19=83-90, then it would out a B in the cell. Anyone know how that works? It didnt work if i just put that into the cell. Thanks

Drew