if value of F2 is <10% over $50 increment, then round value to $50

Hi, I have one more question to finish my worksheet.

This was my original post:
Hi, can anyone tell me what the formula would be to figure my shipping insurance costs? For each $50 of value of F2, it costs .42. The formula i'm using (thanks to this forum!) is =CEILING(F2/50,1)*0.42
this will figure my insurance costs. But, I'd like to add one more column and another formula.

When the value of a package is just over that $50 mark, instead of it costing us .84, I'd rather value it at $50 for a cost of .42.
Can you help me with a formula like IF F2 is within 10% of $50, then change the package value from $55.25 to $50... and I guess that would need the same structure for other tiers. ie: if value is $

if value of F2 is <10% over $50, then change value to $50
if value of F2 is <10% over $100, then change value to $100
a separate column would be best (leave the original formula CEILING(F2/50,1)*0.42) and add another column showing any change??

value of pkg:
$.01-50.00 = .42
50.01-100.00 = .84
100.01-150.00 = 1.26
150.01-200.00 = 1.68
etc

My other two posts re this project including samples of the worksheet are here:
http://www.excelforum.com/excel-gene...worksheet.html
http://www.excelforum.com/excel-gene...osts-42-a.html

THANKS SO MUCH for any suggestions.

Originally Posted by hmm321

Can you help me with a formula like IF F2 is within 10% of $50, then change the package value from $55.25 to $50... and I guess that would need the same structure for other tiers......

That's just the equivalent of using 55 in your formula instead of 50 (55 = 50+10% of 50) so try

=CEILING(F2/55,1)*0.42