Assigning Letter Grades in a grade book

Are you sure you aren't dealing with percentage values?

Try this:
=IF(Total >0.90,"A",IF(Total > 0.80,"B", IF(Total >0.70,"C", IF(Total > 0.60,"D", IF(Total < 0.60, "F")))))

Are you sure you aren't dealing with percentage values?

Try this:
=IF(Total >0.90,"A",IF(Total > 0.80,"B", IF(Total >0.70,"C", IF(Total > 0.60,"D", IF(Total < 0.60, "F")))))

In any case, the entire last "IF" can simply be replaced with "F":
=IF(Total >0.90,"A",IF(Total > 0.80,"B", IF(Total >0.70,"C", IF(Total > 0.60,"D", "F"))))

Hello

Why not use a more sophisticated function?



in english the formula would be:

=HLOOKUP(65,A1:F2,2)

And of course, the cells in which you "HLOOKUP" may be an auxiliary table.

Yvan KOENIG (from FRANCE mardi 11 septembre 2007 19:05:54)

Hello

No, VLOOKUP and HLOOKUP are not the same functions. They are not fool in AppleLand 😉

2 is the index of the row from which the function extracts the value to return, given that the first row in the passed cell range is numbered 1.

To be more clear (I apologize but english is not my language) just a sample:

=HLOOKUP(65,A25:G28,3)

means that the function will grab values from the 3rd row in the range 25…28.
Which means that it will peek in row 27.

Neat samples are given in the Help and in the User guide (well done and available for all of us).

Yvan KOENIG (from FRANCE mardi 11 septembre 2007 19:34:10)

I have recently made a grade book in Numbers and used the VLOOKUP function, so I can provide more detailed instructions. Just set up a simple table with your thresholds and appropriate grades:

0 F
60 D
70 C
80 B
90 A

In the cell where you want your letter grade, put the function: = VLOOKUP(reference for your Total column, absolute reference for cell-range of your lookup table, 2, TRUE)

For example, if the values for your totals are in a column starting B2, and your lookup table is in E2 to F6, you could put the following in C2: =VLOOKUP(B2, $E$2:$F$6, 2,TRUE), then copy and paste this into the other C column cells. The $ signs are needed so that the lookup table range stays constant (absolute reference). You can do the same with HLOOKUP by putting making your lookup table with letter grades and ranges in rows rather than columns. The big advantage of using this technique is that you can easily change the ranges for each letter grade and automatically see what effect it has.

Hello

I didn't use absolute reference because, due to a kind of localisation bug, we can't use these references when the system's currency is not the $ (here in France, it is €uro).

Yvan KOENIG (from FRANCE mardi 11 septembre 2007 20:59:58)