Greetings all. I imagine I will be posting a couple of queries, but one step at a time.
My brain has taken a complete departure today and I can’t think of a easy workaround.
I have a product table with a pricing structure. I need to easily calculate the pricing on and return that price to another sheet.
Column A B C
Code Size Price
105 20 $1 (For each one more than $20, add $1 to total)
106 1130<=50 $35
(for each value, calculate individual price)
107 1120<=45 .85
(again for each one – caculate).
For column B, where I have the Size, it shows as text naturally. Rather than calculate line by line, is there any way to reference this pricing table on another sheet to say that when Product 106 is purchased with 27 units, the price per unit will calculate out to $30?
Like I said, complete brain freeze. Unless I create some other sub-unit code and then add on another variable to the equation to differentiate the size variances, is there any other way rather multitude if statements to figure this out?
Your thoughts are appreciated. Thanks.
