Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.
Last reviewed:
How to grade scores on a curve in Excel and Google Sheets
Topic:RANK & statistical aggregatesExcel & Google Sheets
=MIN(A2+10,100)✓
Verified example
Computed by a real spreadsheet engine on the sample data below.
| Raw_Score | Curved |
| 72 | |
| 58 | |
| 91 |
=MIN(A2+10,100)→82
Try it with your data
Edit the grid or formula, then run it through a real spreadsheet engine — no signup.
Sample data — click any cell to edit
Runs server-side · free · no signup
Step by step
- 1Enter raw scores in column A (rows 2 onwards).
- 2Flat curve (add points): In B2 enter =MIN(A2+10,100) — adds 10 points to everyone and caps at 100.
- 3Scale to highest score: Use =A2/MAX($A$2:$A$20)*100 to make the top score 100% and scale everyone else proportionally.
- 4Square-root curve: Use =SQRT(A2/100)*100 to give a bigger boost to lower scores than to higher ones.
Tips
- Calculate the class average with =AVERAGE(A2:A20) before and after curving to verify the curve achieves your target mean — compare in a summary row.
Need it for your exact data?
Describe your columns in plain English and get the precise formula for your sheet, with the right Excel or Sheets syntax.
Frequently asked
Which curving method is fairest?
The scale-to-highest-score method is common for difficult tests since it rewards relative performance. The flat-point addition is simplest but can push scores above 100 without the MIN cap.
How do I curve scores to hit a specific target average?
Add the difference between target and actual average: =A2+(target_avg-AVERAGE($A$2:$A$20)). For a target of 75 and actual average of 62, add 13 points to each score.
More on RANK & statistical aggregates
See all →Reference
RANK.EQ
Returns the rank of a number in a list, assigning the same rank to ties (same as RANK). Essential for leaderboards.
How-toHow to rank values
Rank a number against a list with RANK — highest first or lowest first. Works the same in Excel and Google Sheets.
ReferenceRANK.AVG
Returns the rank of a number, averaging ranks for ties. Useful in statistical analysis where tied ranks should not cluster.
How-toHow to calculate standard deviation
Measure how spread out your numbers are with STDEV for a sample or STDEVP for a whole population. Works in Excel and Google Sheets.
ReferencePERCENTILE
Returns the k-th percentile value from a dataset. Useful for performance benchmarking and threshold analysis.
How-toHow to calculate a weighted average
Combine values and their weights with SUMPRODUCT divided by the total weight. Works the same in Excel and Google Sheets.