Formula help

L

Liz

I’m trying to create a spreadsheet where shipping & handling charges will
calculate automatically based on the shipping table and the sub-total of the
order.

The formula takes place in cell (H30). The formula would look at the
subtotal (H28) and populate shipping charges from the following table.

(F34) $4.95 -- if the subtotal is between -- $0.01 - $25.00 (G34)
(F35) $5.95 -- if the subtotal is between -- $25.01 - $50.00 (G35)
(F36) $7.95 -- if the subtotal is between -- $50.01 - $75.00 (G36)
(F37) $10.95 -- if the subtotal is between -- $75.01 - $100.00 (G37)
(F38) $15.95 -- if the subtotal is between -- $100.01 - $250.00 (G38)
(F39) $19.95 -- if the subtotal is between -- $250.01+ (G39)

Thank you in advance for the help!
 
L

Liz

Got it!! and thank you!
--
Thanks! Liz


Don Guillett said:
Look in the help index for VLOOKUP and make a table
..01 4.95
25 5.95
etc

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
(e-mail address removed)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top