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
------------------------------
Original Message:
Sent: 08-21-2020 08:26
From: Mike McCartney
Subject: Multi level formula
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
------------------------------