formula
 

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

formula
 

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

HTH

"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

formula
 

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

formula
 

Misread your posting ... sorry!

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



"Toppers" wrote:

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

HTH

"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

formula
 

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

formula
 

Thanks !!

"David Biddulph" wrote:

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