Curve a Grade (Add Points or Scale)

Excel Formulas › Education & Grading

All versionsMIN

Curving lifts scores when a test runs hard. Two common methods: add a flat number of points (capped at 100), or scale everyone so the top score becomes 100. Both are one short formula.

Quick formula: flat curve, capped at 100:
=MIN(score + curve_points, 100)
Add the curve, but cap at 100 so no one exceeds a perfect score.

Functions used (tap for the full reference guide):

MIN

The example

Add 7, capped at 100.

AB
1RawCurved
28592
396100

The formula

The formula:

=MIN(B2 + curve_points, 100) // add points, cap at 100

How it works

How it works:

  1. Flat curve: MIN(score + points, 100) adds a fixed boost without exceeding 100.
  2. Top-score scale: score / MAX(scores) * 100 stretches the highest score to 100.
  3. Square-root curve: SQRT(score) * 10 lifts low scores more than high ones.
  4. Pick the method your grading policy allows, and apply it consistently to the whole class.

Each curve has a personality. A flat add shifts everyone equally; top-score scaling rewards relative standing; a square-root curve compresses the bottom upward (a 49 becomes 70, a 100 stays 100). Show students which method you used — the same raw score yields very different curved grades.

Try it: interactive demo

Live demo

Raw score and flat curve points.

Flat · √-curve

Variations

Scale to top score

Top = 100:

=score / MAX(scores) * 100

Square-root curve

Lift the bottom:

=MIN(SQRT(score) * 10, 100)

Bell to a target mean

Shift the average:

=score + (target_mean - AVERAGE(scores))

Pitfalls & errors

Cap at 100. Use MIN so a flat curve doesn’t push scores over 100.

Apply uniformly. Curve the whole class with the same method for fairness.

Lock the MAX/AVERAGE. Use absolute references so every row scales against the same statistic.

Practice workbook

📊
Download the free Curve a Grade (Add Points or Scale) practice workbook
A grade-curve sheet with the top-score, square-root, and target-mean variants, plus 4 challenges with answers. No sign-up required.

Frequently asked questions

How do I curve a grade in Excel?
For a flat curve use =MIN(score + curve_points, 100); to scale the top score to 100 use =score / MAX(scores) * 100.
What is a square-root curve?
=MIN(SQRT(score) * 10, 100) lifts low scores more than high ones — a 49 becomes 70 while a 100 stays 100.
How do I curve to a target average?
Shift every score: =score + (target_mean - AVERAGE(scores)), with AVERAGE locked by absolute references.

Stop fighting formulas. Learn them in a day.

This recipe is one of hundreds of real-world formulas we teach. Our Excel Formulas & Functions class covers lookups, logic, text, and dynamic arrays hands-on — live in Dallas–Fort Worth, Houston, Austin, Oklahoma City, Denver, or online.

See the Formulas & Functions Class

Related formulas: Min if criteria · Letter grade from score · Normalize min-max

Function references: MIN