Result needed

[teppie_d]

I'm thinking I can use an "If" statement, but I'm not sure exactly how to set it up. I have a variety of numbers:, 25, 102, 151, etc. I need a formula that will give me the following results:

Result Needed Data
$500 1-90 i.e. 25
$1000 91-180 i.e. 102 or 151
$1500 181-270

How do I tackle this?

 

[Oaktree]

=LOOKUP(A1,{1,500;91,1000;181,1500}) if the returned value is capped at 1500

Or =500*ROUNDUP(A1/90,0) if the trend continues

 

[teppie_d]

The lookup one worked perfectly. Thank you!