#value, error. Making small Database in Excel need help

Im working on a small database that just pulls two attributes. membership and referrals. I got that working but there is also price too.

membership referrals price
standard 0 0.28
standard 250 0.29
standard 500 0.3
standard 700 0.31
standard 1000 0.31
golden 0 0.26
golden 200 0.27
golden 500 0.28
golden 700 0.29
golden 1000 0.3

this is part of the database, now i have it so they can enter there membership and then they need to put in how many referrals they have.
ex. i put in standard 250 the price will show .29
but if i put standard 247 it will not work and show value.

How do i make the database in ranges like 0-249 then 250-499... 500-699
so if i do enter in 247 it will show 0.28

**edit
may have posted this in the wrong section... im new =P

Try this,

G3

Please Login or Register  to view this content.

committed with Ctrl+Shift+Enter.

You can also see attached.
Hope this helps,
windknife

WOW u all are amazing all these methods. Thanks a million =D