I used to use schoolhouse to keep track of all my homework and grades, but since that's abandonware now I'm using iWork to at least keep track of grades. As far as individual grades go, I've got my sheets in Numbers worked out fine. I have a cell that calculates my overall grade in the class, but I'd also like to have a cell that shows my grade points in the class. To do this, the cell would have to know that if my grade (cell E2) is above "90", to show "12." Likewise, anything from 80-89 should show "9", 75-79 should show "6," and 70-74 should show "3."
This is a little complicated for me, so could anyone help me out and tell me how this is done? I got to =IF(E2>=89.5, "12"), but I don't know how to add the other options. Any help would be kindly appreciated.
This is a little complicated for me, so could anyone help me out and tell me how this is done? I got to =IF(E2>=89.5, "12"), but I don't know how to add the other options. Any help would be kindly appreciated.