NFL QB Rating

Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: NFL QB Rating

  1. #1
    New Member
    Join Date
    Jan 2006
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default NFL QB Rating

     
    I am having trouble creating the formula for QB rating in Excel.

    NFL Quarterback Rating Formula
    (National Football League)
    a = (((Comp/Att) * 100) -30) / 20
    b = ((TDs/Att) * 100) / 5
    c = (9.5 - ((Int/Att) * 100)) / 4
    d = ((Yards/Att) - 3) / 4

    a, b, c and d can not be greater than 2.375 or less than zero.

    QB Rating = (a + b + c + d) / .06

    I have most of this, but I don't know how to the "a, b, c and d can not be greater than 2.375 or less than zero" thing.

    I have a, b, c and d in C2, D2, E2, F2 and G2. The numbers go to A2, A3, A4 and A5 and the overall rating goes to B6 (I do it like this because I want it to look clean and organized).

    If anyone can tell me how to do this, I would be greatful for the help. Thanks in advance.

  2. #2
    Board Regular NBVC's Avatar
    Join Date
    Aug 2005
    Location
    Ontario
    Posts
    5,828
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    Use If and Or:

    something like:

    =If(OR((((Comp/Att) * 100) -30) / 20 >2.375,(((Comp/Att) * 100) -30) / 20 <0),"",(((Comp/Att) * 100) -30) / 20)

    replacing Comp and Att for actual cell references/names.

    do the same thing for the others.
    Where there is a will there are many ways. Finding one that works for you is the challenge!

    Microsoft MVP - Excel (2010-2016)



User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

 
DMCA.com