Need Help with a formula....

[igetbombed]

Hello,

I have been wrestling with an Excel formula all day. I'm working on a fantasy baseball cheat sheet. Our leage awards bonus points for batting average. Column Q contains the batting average for each player. The bonus points are as follows:

<274 = 0 points
275-279 = 50 Points
280-284 = 60 Points
285-289 = 70 Points
290-299 = 80 Points
300-309 = 90 Points
310 - 319 = 100 Points
Over 320 = 150 Poiints
=IF(Q3<=274,0,IF(Q3>=275<=279,50,IF(Q3>=280<=284,60,IF(Q3>=285<=289,70,IF(Q3>=290<=299,80,IF(Q3>=300<=309,90,IF(Q3>=310<=319,100,IF(Q3>=320,150))))))))

But It's not working. I get "False" across the board. Can someone help me out here?

Here is what I came up with:

[igetbombed]

Not sure what happened to my post....LOL. After I wrote "over 320 = 150 Points, It should have read "here is what I came up with" followed by my formula.

I then added the "I get False across the board" bit.

[contaminated]

Please change Yur title....

[Larry.LeBlanc@O]

You can use the VLookUp worksheet function (interval form). The final argument should be defaulted so that you don't get the exact form. Excel help and the f sub x (insert function) can show you what to do.

[igetbombed]

Ok,

What do I need to change it too? sorry, I'm new here

[Marcol]

Bit of a mouthful but try

Please Login or Register  to view this content.

[contaminated]

Or this one
=LOOKUP(F18,{0;275;280;285;290;300;310;320},{0;50;60;70;80;90;100;150})

[Marcol]

contaminated

That's the way to go

I just took igetbombeds' formula and "fixed" it

[royUK]

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.