Results 1 to 2 of 2

NFL QB Rating

This is a discussion on NFL QB Rating within the Excel Questions forums, part of the Question Forums category; I am having trouble creating the formula for QB rating in Excel. NFL Quarterback Rating Formula (National Football League) a ...

  1. #1
    New Member
    Join Date
    Jan 2006
    Posts
    1

    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,825

    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



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