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) divid...
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")/F3
SergeiBaklan Ah, ok! That makes sense, I will give it a try. Thank you for the help! 😎
