formula

[Irven griffin]

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

 

[Toppers]

Try:

A1=Order value

=IF(A1>2999.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

HTH

 

[Elkar]

Give this a try:

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

HTH,
Elkar

 

[Toppers]

Misread your posting ... sorry!

=IF(A1>2999.99,A1*0.03,IF(A1>=100,A1*0.08,8))

 

[David Biddulph]

A couple of errors in Toppers' formula, I think. Try:
=IF(A1>2999.99,A1*6%,MAX(A1*8%,8))

 

[Toppers]

Thanks !!

A couple of errors in Toppers' formula, I think. Try:
=IF(A1>2999.99,A1*6%,MAX(A1*8%,8))