Multiple IF's to calculate price based on cost and add handling charge and round price

I am working on following formula but it does not work correctly.

=ROUND(IF(H1<10,H1*2.2+12.5,IF(H1>10,H1*2+10,IF(H1>50,H1*1.8+10,IF(H1>100,H1*1.7+10,IF(H1>150,H1*1.6+10,IF(H1>200,H1*1.55+10)))))),0)-0.03

What I am trying to accomplish is: H1 is the cost of an item and the formula is to automatically calculate the selling price, add shipping/handling, and round the price to end in .97


If H1 is less than 10 then multiply by 2.2 and add 12.5

If H1 is 10 but less than 50 then multiply by 2 and add 10

If H1 is 50 but less than 100 then multiply by 1.8 and add 10

If H1 is 100 but less than 150 then multiply by 1.7 and add 10

If H1 is 150 but less than 200 then multiply by 1.6 and add 10

If H1 is 200 or greater then multiply by 1.55 and add 10

THEN round to nearest .00 and subtract 0.03 so ending number ends in .97


Any help with fixing this formula is so greatly appreciated. It is probably something simple but my mind is blind to it.

~ Roy

One way, there are many, is to create a table with your criteria and use VLOOKUP. I set up at table In J1:L6

=ROUND(H1*(VLOOKUP(H1,$J$1:$L$6,2))+VLOOKUP(H1, $J$1:$L$6,3),0)- 0.03
See attachment

See my formula in your worksheet. This way is good because if you want to make changes, you just change the table.
I put the table on Sheet2 and called it Data.