Hi mikejohn11,

Welcome to the forum!!

Try this formula (currently set to work on a decimal value in cell B2 - change to suit):

=LOOKUP(B2,{0,0.25,0.5,0.75,1.25,1.5,2.5,3.5,4.5,5.5,6.5,7.5,8.5,9.5},{50,100,150,200,250,300,340,380,420,460,500,530,560,600})

Regards,

Robert