Using IF functions to calculate shipping cost and methods

J

jjlandrum

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.
 
P

PeteJ

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

shipping costs using if then 2
Can I automaticly figure "cost" and sale price in Excel? 1
If Function to Calculate Shipping Charges 1
VLOOKUP and multiple columns 6
How to calculate total cost using fixed hourly rate from [h:mm:ss:]? 4
AVERAGE and STDEV functions with logic 1
Help needed to write UDF to calculate value based on 8 conditions 2
Run-Time error '-2147417848 (80010108)': Automation error The object invoked has disconnected from 0

Top