In addition to the IF statement the table lookup function (VLOOKUP) can also
be used to assign letter grades. I calculate a semester total number of
points for each student and use the VLOOKUP to get the letter grade from the
last two columns of a table below the student scores, something like:
T1 T2 total grade
90 90 180 A
80 80 160 B
................
Excel and QPro treat the boundries between grades slightly differently.
Robert Mathieson
Culver-Stockton College
Canton, MO 63435
(217)231-6000
rmathieson@culver.edu