Forum Discussion
Item Size, Item Cost, Ounce Cost
Hi everyone,
I'm looking to auto-populate the cost per ounce by dividing item size to item cost. I have the item size table set with Liter, 750ml and 375ml. So cell G3 would be 11.8(ounces) divided by 27.00 (dollars) to equal 0.437 (dollars). I'm not sure how to handle text like 350ml to equal 11.8 ounces in equation. Thank you for your time and consideration.
| 750ml = 25.4 ounces |
| Liter = 33.8 ounces |
| 350ml = 11.8 ounces |
2 Replies
You may use CONVERT() function like
=CONVERT(IF(Table913[@[Item Size]]="Liter",1,LEFT(Table913[@[Item Size]],LEN(Table913[@[Item Size]])-2))/1000,"l","oz")/F3SergeiBaklan Ah, ok! That makes sense, I will give it a try. Thank you for the help! 😎
