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!
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!