Forum Discussion
Formula average
Hi, I want to find the average price of a product, but the product has 3 different prices - and I want the average based on which one sells most (if that's possible to understand)... ...
Which one sells most? Such question presupposes that there are multiple products with varying quantities of sales, which are missing in your given data. Please provide such data so I can decipher the appropriate formula that will deliver the result you expect.
Also, what do you mean with the given percentages? Do they refer to the sales mix of 3 products? Please clarify.
Also, what do you mean with the given percentages? Do they refer to the sales mix of 3 products? Please clarify.
1 product
3 Prices for the same product (ordinary/student/member)
Ordinary Student Member
Prices 82 54 44
% of sale. 33%. 53%. 14%
So it's one product, but with three different prices. I want to find the average outgoing price for that product, when i sell the product for different prices...
F.ex.:
Ordinary Student
Prices 100 50
% of sale 50% 50%
This would mean that the average outgoing price for the product - depending on how much the different prices sells - is 75.
