Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula/Shipping Chart
I want to be able to say:
If E38 is less than or equal to $17.99 then E44 is E38 plus $5.95 and If E38 is between $18.00 and $23.99 then E44 is E38 plus $6.95 and If E38 is between $24.00 and $39.99 then E44 is E38 plus $7.95 and If E38 is between $40.00 and $49.99 then E44 is E38 plus $8.95 and If E38 is between $50.00 and $74.99 then E44 is E38 plus $10.95 and If E38 is between $75.00 and $89.99 then E44 is E38 plus $12.95 and If E38 is between $90.00 and $119.99 then E44 is E38 plus $14.95 and If E38 is between $120.00 and $249.99 then E44 is E38 plus $16.95 and If E38 is between $250.00 and $499.99 then E44 is E38 plus $18.95 and If E38 is between $500.00 and $599.99 then E44 is E38 plus $21.95 (Shipping on E38 that is $600+ is on another scale, which I don't need in this formula.) Thank you! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I create a formula that calculates shipping costs? | New Users to Excel | |||
How do I create a formula that calculates shipping costs? | New Users to Excel | |||
Shipping price, maybe challenge of the day | Excel Worksheet Functions | |||
shipping costs using if then | Excel Worksheet Functions | |||
Multiple Shipping problem | Excel Worksheet Functions |