Skip to main content
Question

Multi level formula

  • Aug 21, 2020 12:26 PM UTC
  • 0 replies
  • 100 views

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



------------------------------
Mike McCartney
------------------------------
This topic has been closed for replies.

  • Author
  • Observing
  • Aug 22, 2020 12:54 AM UTC
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
------------------------------