A couple of errors in Toppers' formula, I think. Try:
=IF(A12999.99,A1*6%,MAX(A1*8%,8))
--
David Biddulph

"Toppers" wrote in message
...
Try:

A1=Order value

=IF(A12999.99,A1*0.03,IF(A1=100,A1*0.08,A1*0.08) )

Iassume that below $100 is NOT 8% i.e is not the same as $100-$2999.99,
although that is what I have put in the formula

"Irven griffin" wrote:

I need help with a formula to calculate shipping costs on a spreadsheet,
I
have 3 different calculations,1, if the order is over $2999.99 the cost
is
6%, 2, if the order is between $100.00 and $2999.99 the cost is 8%, 3,
if
the order is below $100.00 the cost is $.8.00
--
muskrat