Excel Ranger
Board Regular
- Joined
- Oct 31, 2005
- Messages
- 54
- Office Version
- 365
- 2016
- Platform
- Windows
- MacOS
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.
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.