Solved

# Excel formula for NFL passer rating

Posted on 2011-10-17
1,285 Views
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.
0
Question by:blakogre

LVL 50

Expert Comment

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

regards, barry
0

LVL 9

Author Comment

Ah, yes: P2.  Sorry :-)
0

LVL 50

Expert Comment

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

LVL 50

Expert Comment

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

LVL 50

Accepted Solution

..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

LVL 9

Author Closing Comment

That seems to work, thanks :-)
0

## Featured Post

### Suggested Solutions

Advanced finding in Excel 9 24
IF OR formula Excel 8 23
Sum Per Month 7 23
Word 2016 stuck on "starting" splash screen 10 27
Improved? Move/Copy Add-in Replacement - How to avoid the annoying, “A formula or sheet you want to move or copy contains the name XXX, which already exists on the destination worksheet.” David Miller (dlmille)  It was one of those days… I wa…
This tutorial explains how to create a series of drop-down lists that are dependent upon prior selections to guide (“force”) the user to make the correct selection and reduce data errors within Microsoft Excel. Excel 2010 was used for this tutorial;…
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

#### Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!