Assign a 'code' if criteria is met

[Welsh Mark3]

I want to assign a value segment to a range of values I have, the value segments and criteria are shown below. Would filter and manually adding these be the best way to do this? Or is there a formula that would work better?

[TABLE="width: 194"]
<colgroup><col><col></colgroup><tbody>[TR]
[TD]Value Segment[/TD]
[TD]Criteria[/TD]
[/TR]
[TR]
[TD]500[/TD]
[TD]>=250<500[/TD]
[/TR]
[TR]
[TD]750[/TD]
[TD]>=500<750[/TD]
[/TR]
[TR]
[TD]1000[/TD]
[TD]>=750<1000[/TD]
[/TR]
[TR]
[TD]2500[/TD]
[TD]>=1000<2500[/TD]
[/TR]
[TR]
[TD]5000[/TD]
[TD]>=2500<5000[/TD]
[/TR]
[TR]
[TD]7500[/TD]
[TD]>=5000<7500[/TD]
[/TR]
[TR]
[TD]10000[/TD]
[TD]>=7500<10000[/TD]
[/TR]
[TR]
[TD]Greater[/TD]
[TD]>=500<756[/TD]
[/TR]
[TR]
[TD]Zero[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]250[/TD]
[TD]>=250<500[/TD]
[/TR]
</tbody>[/TABLE]

 

[mole999]

you could use VLOOKUP from a reference table or LOOKUP