How To Grade 40 Students relitively On a Normal Distribution.

A

Atishoo

I couldnt post a reply to your question for some reason.
In fact Im not even sure exactly what your question is however:
There is an interesting example of nested If functions around grading
results as follows:
A
1 Score
2 45
3 90
4 78

=IF(A2>89,"A",IF(A2>79,"B", IF(A2>69,"C",IF(A2>59,"D","F")))) Assigns a
letter grade to the first score (F)
=IF(A3>89,"A",IF(A3>79,"B", IF(A3>69,"C",IF(A3>59,"D","F")))) Assigns a
letter grade to the second score (A)
=IF(A4>89,"A",IF(A4>79,"B", IF(A4>69,"C",IF(A4>59,"D","F")))) Assigns a
letter grade to the third score (C)

May not be what your looking for but i like it so posted it anyway!
Is what your looking for a formula to show deviation from a pre defined mean
score?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need (Excel) formula to make Mark sheet with Automatic Grading 13
VLOOKUP to find a value that falls between a range? 3
Including a range of number in a IF (Logical Test) formula 5
How to Create VLookup for a range of specified grades? 5
Sum of Variable Cells in a fixed Row 3
Match & Vlookup Function 1
FUNCTION IF 1
Urgent help with Excel formula. Please please help 1

Top