# iWork - Numbers advanced formulas

Discussion in 'Mac Apps and Mac App Store' started by kevindosi, Feb 2, 2009.

1. ### kevindosi macrumors regular

Joined:
Mar 16, 2006
#1
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.

2. ### kevindosi thread starter macrumors regular

Joined:
Mar 16, 2006
#2
well, in case anyone is interested, i found the answer nowhere other than in microsoft excel's help file!
=IF(E2>89.5,"12",IF(E2>79.5,"9",IF(E2>74.5,"6",IF(E2>69.5,"3","F"))))