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.

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.