View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
joaniemic joaniemic is offline
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!