LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 14
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I create a formula that calculates shipping costs? Mark Toulson New Users to Excel 1 October 17th 06 08:33 AM
How do I create a formula that calculates shipping costs? Mark Toulson New Users to Excel 3 October 16th 06 10:40 PM
Shipping price, maybe challenge of the day [email protected] Excel Worksheet Functions 1 November 17th 05 10:24 AM
shipping costs using if then impression Excel Worksheet Functions 2 May 7th 05 11:34 PM
Multiple Shipping problem tjtjjtjt Excel Worksheet Functions 0 November 10th 04 12:03 PM


All times are GMT +1. The time now is 10:05 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"