Feb 23 2019 08:37 AM
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)...
Price 82 54 44
% of product sale 33% 53% 14%
Does anyone know a formula i can use? :)
Feb 23 2019 07:20 PM
Feb 28 2019 08:45 AM
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.
Feb 28 2019 08:50 AM
I got (almost) the same answer, when I used =(B1*B2)+(C1*C2)+(D1*D2). (61,67)
But when I tried to insert the formula you suggested, I get an error code saying there's a problem with the formula(?)...
Feb 28 2019 09:01 AM