Statistical
NFL Quarterback Passer Rating formula (0 to 158.3 Official Scale)
Calculate NFL passer rating with four clamped components and compare it with adjusted yards per attempt (AY/A).
Why the maximum displays as 158.3
NFL passer rating combines completion rate, passing yards per attempt, touchdown rate and interception rate. Each component is limited to the interval from 0 to 2.375 before the sum is scaled by 100/6.
The unrounded maximum is 158.333…; 158.3 is the one-decimal display, not the exact mathematical result. Reaching the ceiling does not require completing every pass. This measure is not ESPN QBR and does not include rushing or sacks.
This example requires numeric integer counts: attempts, completions, touchdowns and interceptions must be nonnegative; completions plus interceptions cannot exceed attempts, and passing touchdowns cannot exceed completions. Passing yards can be negative. No attempts yields N/A rather than zero.
| Passer Component | Clamped Formula [0, 2.375] | 25/35, 315 Yds, 3 TD, 1 INT | Perfect Game (16/20, 260, 3, 0) |
|---|---|---|---|
| a: Completion % | MIN(2.375, MAX(0, ((B3/B2)-0.3)*5)) | 2.0714 (71.4% CMP) | 2.3750 (80.0% >= 77.5%) |
| b: Yards / Attempt | MIN(2.375, MAX(0, ((B4/B2)-3)*0.25)) | 1.5000 (9.0 YPA) | 2.3750 (13.0 >= 12.5 YPA) |
| c: Touchdown % | MIN(2.375, MAX(0, (B5/B2)*20)) | 1.7143 (8.57% TD) | 2.3750 (15.0% >= 11.88%) |
| d: Interception % | MIN(2.375, MAX(0, 2.375 - (B6/B2)*25)) | 1.6607 (2.86% INT) | 2.3750 (0.0% INT) |
| Official NFL Rating | ROUND(((a + b + c + d) / 6) * 100, 1) | 115.8 Rating | 158.3 Perfect Rating! |
Complete Official NFL Passer Rating Formula (0.0 to 158.3)
Clamps each of the four sub-scores into [0, 2.375] with MIN and MAX before scaling by 100 / 6.
=IF(COUNT(B2:B6)<>5,"Invalid inputs",IF(OR(B2<0,B3<0,B5<0,B6<0,B2<>INT(B2),B3<>INT(B3),B5<>INT(B5),B6<>INT(B6),B3+B6>B2,B5>B3),"Invalid inputs",IF(B2=0,"N/A",ROUND(((MIN(2.375, MAX(0, ((B3 / B2) - 0.3) * 5)) + MIN(2.375, MAX(0, ((B4 / B2) - 3) * 0.25)) + MIN(2.375, MAX(0, (B5 / B2) * 20)) + MIN(2.375, MAX(0, 2.375 - ((B6 / B2) * 25)))) / 6) * 100, 1))))Adjusted yards per attempt (AY/A)
This companion formula is AY/A: it adjusts passing yards for touchdowns and interceptions. It is not adjusted net yards per attempt (ANY/A), which additionally accounts for sacks and sack yards. AY/A can be negative and is not clamped to the passer-rating scale.
=IF(COUNT(B2:B6)<>5,"Invalid inputs",IF(OR(B2<0,B3<0,B5<0,B6<0,B2<>INT(B2),B3<>INT(B3),B5<>INT(B5),B6<>INT(B6),B3+B6>B2,B5>B3),"Invalid inputs",IF(B2=0,"N/A",ROUND((B4 + 20 * B5 - 45 * B6) / B2, 2))))Try the example
Use the original values or change them to test your understanding.