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. 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. 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.

Posting Permissions

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