JV's solution is the right one, BUT, in double-checking his quick response, there are TWO potential problems.
1) If a student's score is LESS than .50, then the formula will return "#N/A". One solution is to use "0" in place of the .50, causing ANY score below .70 to be graded as "F".
2) If "JJOHNS" intends to copy the formula - i.e. for application to a number of rows for other students' scores - then there will be a NEED to make the reference to the table "ABSOLUTE". Otherwise, the cell reference to the table range will CHANGE when the formula is copied.
Making the reference to the table "ABSOLUTE" can be done by placing the cursor on the table's cell references and using the "F4" function key. This will insert "$" characters which causes the cell references to remain ABSOLUTE.
However the BEST method of creating an "absolute" reference in a formula, is to create a "Range Name". After creating an arbitrary Range Name ("grade" would be appropriate in this case), Excel will simply accept the range name. AND, when the formula is copied, the range name STAYS AS IS - i.e. it remains "ABSOLUTE".
For those not aware of the "easy" method of creating a "Range Name", use these steps:
1) Highlight the range you want to name,
2) Hold down the "Control" key, and hit the "F3" key,
3) Type in the (arbitrary) name you wish to use, and hit the "Enter" key.
Hope this provides a valued "assist" to JV's solution.
Regards, ...Dale Watson dwatson@bsi.gov.mb.ca
