Excel Formula

[Guest]

I'm trying to find an excel fomula that will calculate the discounted price
of different products from different suppliers.

 

[Mangus Pyke]

I'm trying to find an excel fomula that will calculate the discounted price
of different products from different suppliers.

That's nice.

Could you give a little more information?

MP-

 

[Guest]

Here is an example of what I want, maybe that will help. I have three Vendors
A,B,C. Vendor A has products 1 (price $100.00) product 2 (Price $75.00) and
product 3 (price $ 50.00) Vendor B has products 1 (price $112.50) product 2
(Price $87.50) and product 3 (price $ 44.00) and Vendor C has products 1
(price $130.00) product 2 (Price $90.00) and product 3 (price $79.00)
I want to know what is the percent discount cost of each product between
each Supplier, A,B, and C.

 

[Mangus Pyke]

Here is an example of what I want, maybe that will help. I have three Vendors
A,B,C. Vendor A has products 1 (price $100.00) product 2 (Price $75.00) and
product 3 (price $ 50.00) Vendor B has products 1 (price $112.50) product 2
(Price $87.50) and product 3 (price $ 44.00) and Vendor C has products 1
(price $130.00) product 2 (Price $90.00) and product 3 (price $79.00)
I want to know what is the percent discount cost of each product between
each Supplier, A,B, and C.

Ok, that tells me about your data set. I think the confusion is based
in terminology. When you say "discount", I think you're referring to
a lowered price.

Are you wanting to know difference from mean price? Or percentage
over minimum cost?

MP-

 

[Guest]

I'm doing this for my grandfather's radiator shop, but I'm going to say the
mean price

 

[Mangus Pyke]

I'm doing this for my grandfather's radiator shop, but I'm going to say the
mean price

If you want to compare each vendor's price to the mean price for the
product, I put the vendors in columns B, D, and F, and the product
prices in rows 2, 3 and 4 below the vendor. In the column after each
price, I wanted the comparison of that price to the mean. So I put
the following in cell C2 and the copied/pasted it into E2 and G2, then
dragged it down:

=B2-AVERAGE($B2,$D2,$F2)

It gave me this:

Vendor A Vendor B Vendor C
Prod 1 $100.00-$14.17 $112.50-$1.67 $130.00 $15.83
Prod 2 $75.00 -$9.17 $87.50 $3.33 $90.00 $5.83
Prod 3 $50.00 -$7.67 $44.00 -$13.67 $79.00 $21.33

Is that what you're looking for?

MP-

 

[Guest]

that helps....but he is wanting the percent discount