Formula help

[Guest]

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!

 

[Don Guillett]

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

 

[Guest]

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

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)

 

[Guest]

I spoke to soon, still having issues

 

[Don Guillett]

still having issues
Always nice to tell folks what you mean.

 

[Don Guillett]

Answered privately. OP was not looking up proper value