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.
Put this in F1 and copy down:
=IF(OR(D1="4X",D1="5x"),E1*18,IF(OR(D1="2X",D1="3X"),E1*17,E1*15))
SPARTAN
Please click the * if my solution helped
jmbones,
Welcome to the forum!
When you have a list of items you'll be looking up, it's generally recommended to make a lookup table. That way, should the price values ever change, it's much easier to update the table rather than dig through a formula (or multiple formulas).
The most common lookup function for this task is the VLookup() function. Attached is an example workbook to show you how it works.
In the example workbook, the size/price table that will be used by the VLookup function is in columns I and J (these can be hidden if you want). Then in cell F2 and copied down is this formula:
=VLOOKUP(D2,$I$2:$J$9,2,FALSE)*E2
Hope that helps,
~tigeravatar
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
You folks are great. Thanks for the quick replies. The vlookup did it.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks