Gradebook fomulas on Excel?

Question

I'm doing a gradebook assignment in PC science and have forgotten the formula for letter grades that will change automatically with the grade avg, over the summer. Could someone help me out? i need it for like <= 59.4 "F" and so on. THANX!

Answer 1

You can accomplish this by using nested loops within the IF function

Lets say that the value you are evaluating the average located in cell A1:

=IF(A1>=89.5, "A", IF(A1>=79.5, "B", IF(A1>=69.5, "C", IF(A1>=59.5, "D", "F"))))

For more information about nested loops look in the Help section of Excel:

Help Menu --> Microsoft Excel Help --> then search the term "IF worksheet function"     --> scroll down and read the section about nested loops

Up to seven IF functions can be nested as value_if_true and value_if_false arguments to construct more elaborate tests.

***Just so you know, if you were to use "if(A5 <= 59.4, "F" , if(A5 <=69.4 , "B" , ... ) )" then a 59.41 would count as a "D" rather than an "F". It would be better to write it as "if(A5 >= 89.5 , "A" , if( A5 >= 79.5 , B , ... ) )"

Answer 2

You can use a nested if statement or you could use a table in another worksheet with a vlookup formula. The table could be formatted like this.

100 A
90 A
89.99 B
80 B

and so on.

Then, when you calculate the grade score (ex: 93), you use a vlookup to find that value on the table, and have it give you the grade (A).

I have used this for many classes without any problems, and the reason I prefer it over the nested if is that it is easier to change the scale if needed.

Email me if you need help.

Answer 3

Use the motor vehicle sum button. It looks like an peculiar letter E or the Greek sigma. click it interior the cellular which you relatively elect the completed for, then drag your mouse interior the path of the cells which you relatively elect totaled, then hit enter. in case you click decrease back on the cellular that has to finished, you ought to use the motor vehicle fill handle (that's on the backside suitable of the chosen cellular). click it and drag down the column the place you have chose all the totals to look, then the formulation would be copied for the the rest rows.

Answer 4

The if formula can be used, but for letters A, B, C, D, F you will need to nest 5 of them. Like this:

=if( A5 <= 59.4, "F", if( A5 <= 69.4, "D", if ( A5 <= 79.4, "C", if ( A5 <= 89.4, "B", "A"))))

A bit messy, but it should work.