Multi level formula

Question

I want to calculate the NFL QB Passer Rating, but not sure best way to do this.  Here is the explained process:

Formula 1: Take the completions/attempts, subtract .3 and multiply the result by 5.
Formula 2: Take the passing yards/attempts, subtract 3 and multiply the result by .25.
Formula 3: Take the touchdowns/attempts and multiply the result by 20.
Formula 4: Take 2.375 minus the result of interceptions/attempts multiplied by 25.

After calculating each of the four formulas, there is one final formula required to generate your passer rating:

NFL Passer Rating = The sum of the results of Formula 1, Formula 2, Formula 3, and Formula 4 divided by 6. That result is then multiplied by 100.
------------------------------Mike McCartney------------------------------

MikeMcCartney · Answer

I believe I got it:((((([Pass Comp]/[Pass Att])-0.3)*5)+(((([Pass Yards]/[Pass Att]))-3)*0.25)+((([Pass TD]/[Pass Att]))*20)+(2.375-(([Pass INT]/[Pass Att]))*25))/6)*100------------------------------Mike McCartney------------------------------

Sign up

Login to the community