Help With An Excel Formula For Grades?

1. Mickey Mouse Spears Says

   First you have to create a table for each possible number of points. I usually put this table on a seperate worksheet (the tabs at the bottom of Excel) within the same workbook. So, for example, in column cells A1 to A5, you put the numbers 1 through 5. Then in cells B1 to B5, you put F. Continue through the possible scores and grades, so that the numbers and their corresponding grades are in the cells next to one another.
   Once that’s done, you can do a VLOOKUP function. You would want to use the function wizard for this (the little fx button at the top of excel). You will only have to do this once, then you can copy it down to all of the other students.
   In the “lookup value” field, click on the actual grade of the student whose row (or column) is active. For Table array, select the table you created — the entire thing. For Col_Index_num, you enter the number of columns between the original score and the letter grade that you want to appear, so if the number appears in column A, and the letter grade is in column B, you actually enter 2. If the letter grade appeared in column C, you would enter 3.
   In the range_lookup field, enter 0. Always. I don’t know why.
   Once you’re done, you should see the letter grade appear in the cell.
   Then select that cell, and all the cells beneath, and type CTRL+D, and all of the student’s grades should populate in that column. Voila! You’re done.

2. Vicky Says

   Example
   —-A
   1–Score
   2–45
   3–90
   4–78
   Formula
   =IF(A2>89,”A”,IF(A2>79,”B”, IF(A2>69,”C”,IF(A2>59,”D”,”F”))))
   Description
   Assigns a letter grade to the score in cell A2
   Result
   F
   Formula
   =IF(A3>89,”A”,IF(A3>79,”B”, IF(A3>69,”C”,IF(A3>59,”D”,”F”))))
   Assigns a letter grade to the score in cell A3
   A
   Formula
   =IF(A4>89,”A”,IF(A4>79,”B”, IF(A4>69,”C”,IF(A4>59,”D”,”F”))))
   Description
   Assigns a letter grade to the score in cell A4
   Result
   C

3. Anonymous Says

   use the lookup function
   example (open in excel)http://www.wfu.edu/~matthews/plus_minus/…

4. ʞɔıɯ Says

   it’s an IF formula, the Excel help will take you further

Leave a Reply

You must be logged in to post a comment.