| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Formula help
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Regression Leverage Formula (Jerry W. Lewis or Mike Middleton)already have DFITS formula | Excel Worksheet Functions | |||
| Build excel formula using field values as text in the formula | Excel Worksheet Functions | |||
| Formula expected end of statement error, typing formula into cell as part of VBA macro | Excel Programming | |||
| Cell doesn't show formula result - it shows formula (CTRL + ' doe. | Excel Worksheet Functions | |||
| Commenting custom formula fields/formula on formula editor | Excel Programming | |||
Linear Mode
