| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using IF functions to calculate shipping cost and methods
In my workbook, I have cell B12 as my shipping options, and cell B17 as
shipping cost. In range of D40:F41 I have Standard $9.50, Express $14.50, and Overnight $18.50. I cant figure out how to use an IF function to display the costs of the shipping in cell C17. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Using IF functions to calculate shipping cost and methods
I think a lookup would be easier than multiple "IF's. Likes like the shipping
options are arranged horizontally, so how about: B17 = hlookup(B12, D40:F41, 2) Not quite sure what C17 has to do with this, I assume it's a typo and you meant B17. - Pete "jjlandrum" wrote: In my workbook, I have cell B12 as my shipping options, and cell B17 as shipping cost. In range of D40:F41 I have Standard $9.50, Express $14.50, and Overnight $18.50. I cant figure out how to use an IF function to display the costs of the shipping in cell C17. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculate X1-5 and Y? If total cost is given. | Excel Discussion (Misc queries) | |||
| Calculate call cost in seconds | Excel Worksheet Functions | |||
| How to calculate future cost of roof | Excel Worksheet Functions | |||
| How to calculate shipping costs based on subtotal | Excel Worksheet Functions | |||
| Calculate time and cost | Excel Worksheet Functions | |||
Linear Mode
