AR1Redneck
Thread Starter
- Joined
- Dec 13, 2002
- Messages
- 206
Hi all, i am doing this project for my school work. Its a grading system project. Ok let me see if i can explain it good enough for you to understand.
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
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