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


"Don Guillett" wrote:


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

"Liz" wrote in message
...
Im 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!

--
Thanks! Liz