Grade Curve Calculator › Curve Grades in Excel
How to Curve Grades in Excel
You can absolutely curve grades in Excel — here are the exact formulas for each method. But if you'd rather skip the cell references, capping logic, and copy-paste errors, there's a faster way at the end.
Set up your sheet
Put raw scores in column A starting at A2. We'll write
the curved result in column B. Assume a maximum of 100; adjust if
your test is out of something else.
1. Flat curve (add points)
=MIN(A2 + 10, 100)
Adds 10 points and caps at 100 so nothing exceeds the maximum. Change
10 to your boost. This is the spreadsheet version of a
flat curve.
2. Linear curve (rescale the range)
First compute the class min and max once (e.g. in D1 and
D2):
D1: =MIN(A:A) D2: =MAX(A:A)
Then, to land the lowest score on 60 and the highest on 100:
=(A2 - $D$1) / ($D$2 - $D$1) * (100 - 60) + 60
Everyone is mapped proportionally between the floor and ceiling — see the linear curve for the reasoning.
3. Square root curve
=SQRT(A2 / 100) * 100
A gentle, progressive boost that helps lower scores most. More in our square root curve guide.
4. Bell curve (normal distribution)
Compute the class mean and standard deviation once:
D3: =AVERAGE(A:A) D4: =STDEV.P(A:A)
To re-center to a mean of 75 with a standard deviation of 10:
=75 + ((A2 - $D$3) / $D$4) * 10
This converts each score to a z-score and places it on the new distribution. Be
careful: this method can push scores above 100 or below 0, so you may need to
clamp with MIN/MAX. See
bell curve grading for the caveats.
Where Excel gets painful
- Capping and clamping. Every method needs guard rails so scores stay in range — easy to forget.
- No visual feedback. You can't see the before/after distribution without building a chart by hand.
- Comparing methods. Trying four curves means four columns and a lot of re-typing.
- Mistakes hide. A wrong absolute reference (
$) silently corrupts the whole column.
The faster alternative
Our free grade curve calculator does all of the above in seconds: paste your scores, switch between flat, linear, square root, and bell curve methods, see the before/after distribution chart instantly, and export a CSV straight into your gradebook. The bounds and caps are handled for you, and every method shows its formula so you can still explain exactly what happened. New to curving? Start with our pillar guide on how to curve grades.
FAQ
What's the Excel formula to curve so the highest score is 100?
Use a ratio scale: =A2 / MAX(A:A) * 100. Every score is multiplied by the same factor so the top reaches 100 and proportions are preserved.
How do I curve grades by 10 points in Excel?
=MIN(A2 + 10, 100) — add 10 and cap at the maximum so no score exceeds 100.
Is the calculator more accurate than Excel?
It uses the same formulas, but removes the manual steps where errors creep in — capping, clamping, and absolute references are all handled automatically.