|
Formula help
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 |
Formula help
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 |
Formula help
I spoke to soon, still having issues
-- 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 |
Formula help
still having issues
Always nice to tell folks what you mean. -- Don Guillett Microsoft MVP Excel SalesAid Software "Liz" wrote in message ... I spoke to soon, still having issues -- 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 |
Formula help
Answered privately. OP was not looking up proper value
-- Don Guillett Microsoft MVP Excel SalesAid Software "Liz" wrote in message ... I spoke to soon, still having issues -- 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 |
| All times are GMT +1. The time now is 08:12 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com