Hi,

Trying to get a formula to calculate the price of an item depending on the size and quantity.

For example, if size = 2X, then price = $17.

Sizes are in column D, total price should be in column F. Would also like to include the price multiplied by the quantity (column E). Is this possible?

The size and price data is:
S, M, L, XL = $15
2X, 3X = $17
4X 5X = $18.