| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
I am trying to set a letter grade for my students, HELP
I followed the formula that help suggested, it was a IF statement, one way it
turns out false, the other way the only grade that will show is an A. The formula is as follows: =IF(H24<89, "A", IF(H24<79,"B", IF(H24<69, "C","F"))). When I try this it alwasy returns an A, now the students would like that, but, I would have a hard time explaining why everyone got the same grade. Help if you can. Thank You, this is my first post. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Numerical grade to Alpha character | Excel Discussion (Misc queries) | |||
| Converting Letter Grades to Numeric | Excel Worksheet Functions | |||
| How can I assign a number value to a letter grade in Excel? | Excel Worksheet Functions | |||
| need if-then formula-If a number is > /< something, then place a . | Excel Worksheet Functions | |||
| Have A Letter Reference A Name For An Intoduction | New Users to Excel | |||
Threaded Mode
