# Excel formula for NFL passer rating

I've got columns for completions / attempts / TDs / interceptions --

I need a formula for passer rating.  I can't seem to get an accurate one that matches NFL stats.

Presume Completions is C2, Attempts is A2, TDs is T2, and Interceptions is I2

Thanks.
LVL 9
###### Who is Participating?

Commented:
..and here's an example using that last formula

I checked with an online calculator and it appears to give the correct results

regards, barry
27400456.xls
0

Commented:
According to Wikipedia you also need Passing Yards for the NFL version - do you have that?

regards, barry
0

Author Commented:
Ah, yes: P2.  Sorry :-)
0

Commented:
Try this formula for the rating

=(MEDIAN(0,2.375,(C2*100/A2-30)/20)+MEDIAN(0,2.375,T2*100/A2/5)+MEDIAN(0,2.375,T2*100/A2/5)+MEDIAN(0,2.375,(P2/A2-3)/4))/0.06

regards, barry
0

Commented:
Sorry, that was wrong, I repeated the touchdown calculation and missed out the interceptions - should be like this

=(MEDIAN(0,2.375,(C2*100/A2-30)/20)+MEDIAN(0,2.375,2.375-I2*25/A2)+MEDIAN(0,2.375,T2*100/A2/5)+MEDIAN(0,2.375,(P2/A2-3)/4))/0.06

regards, barry
0

Author Commented:
That seems to work, thanks :-)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.