Need help writing an expression to find a Quarterbacks Passer Rati

C

Chartswife

I'm trying (without success) to write a formula to use in a table to figure
the NFL quarterbacks passer rating. Here are the components, and I believe my
errors are the maximum and minimum and not knowing how to use them in the
formula:
C= Comp/Att*100-30/20
Y= YDS/Att-3*.25
T= TD/Att*20
I= 2.375-INT/Att*25

The four components are then added and divided by 6 and multiplied by 100,
so the formula for passer rating is given as:

(max(min(C,2.375),0)+max(min(Y,2.375),0)+max(min(T,2.375),0)+max(min(I,2.375),0)*100/6

I have played for 3 days with this monster formula and have not figured it
out. Can anyone help?
 
C

Chartswife

I'm using vista, access 2007 ( default save to 2003), sorry, forgot to add
with question
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top