Using IF functions to calculate shipping cost and methods

  • Thread starter Thread starter jjlandrum
  • Start date Start date
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.
 
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
 
Back
Top