If conditional formatting, (I think)

[OverHeight]

Hi, first post here. I had a hunt for what I think I want, but couldn't see anything.

I need to calculate the amount of insurance on a shipment based on the value of the shipment.

The FIRST $100.00 is FREE
$100.01-$300.00=$2.90
$300.01 AND UP is $0.95 PER $100.00
So if the price of the item was $525.00 = $2.90 plus $0.95 plus $0.95 plus $0.95 =$5.75
So if the price of the item was $499.00 = $4.80
So if the price of the item was $601.00 = $6.70

Hope that makes sense.

Thanks in advance

[ChemistB]

One way

=IF(A1<100.01, 0, 2.9 +MROUND(MAX(ROUNDUP(A1,0)-300,0)+49,100)/100*0.95)
I might have made it more complicated than it needed to be.

[OverHeight]

Complicated or not, it works. Thanks for the quick response!