Values in cell help (easy)

[mtaystl11]

Hello. Thanks in advance for your help. I feel like a dummy asking this questions but...

I am working on a fantasy football scoring sheet that will update immediately as I put in the stats. I run into a snag when I get to defensive points allowed. My question is this: How do I get a cell to award a certain amount of points for a range of different values.

Here is the way it works.

0-0 points allowed = 10 points
2-6 points allowed = 7 points
7-13 points allowed = 5 points
14-20 points allowed = 2 points
28-34 points allowed = -2 points
35+ points allowed = -4 points

So in that cell when I put in 12 - I would want it to display 5 points.

Thank you so much!

[duane]

Just set up a table let's say in a1:b6 somewhere

column A column B
0 10
2 7
7 5
14 2
28 -2
35 -4

if your point value is in cell c1

=vlookup(c1,a1:b6,2)