Hi Robbie

Try this formula, it should be self explanatory as to how to change the multiplier to what you want:

=IF(A1<10.01,A1*10,IF(A1<50.01,A1*20,IF(A1<100.01, A1*30)))

Tony (OTPM)