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

calculate shipping costs in excel 2007 3
shipping costs using if then 2
Help making postage calculator based on a given weight 3
Using IF, AND and OR functions together 2
Can I automaticly figure "cost" and sale price in Excel? 1
If Function to Calculate Shipping Charges 1
if command with tiers 2
Is an array the best option for me and if so how ? 1

Top