| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
