Give this a try:

=IF(A1=3000,A1*0.06,MAX(A1*0.08,8))

HTH,
Elkar


"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