Hi karch35

There is no standard way to do this in Excel. You could use the nested =IF() function if you had less than 7 conditions - but you haven't. The function I wrote for you will do exactly what you asked for - you didn't list all the parameters, I worked on the ones you listed. If you want more conditions, then just add new lines before the End Function command:
If a >= 300 And a <= 350 Then Points = 100

You may have to spend a little time setting this up in the first place, but you have to balance this against how much time it will (or won't save). If the alternative is going through 000's of lines every week putting in these values manually or spending time listing all the conditions, I know which I'd prefer...

HTH

DominicB