Help with IF THEN Formula

[TangoDiva2614]

I am working on a formula and I am getting stuck.

IF Cell A2<100% then I need cell B2=0

A2 is >= 100% , but <125% then I need Cell B2=125
If A2>100% but =<125% then B2=150
If A2>=150% then B2=175

Thanks!

[tim201110]

=lookup(a2,a4:b7)

[Sam Capricci]

this would work...
=LOOKUP(A2,{0,1,1.26,1.5},{0,125,150,175})