Excel Formula

C

Court1002

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

Mangus Pyke

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

That's nice.

Could you give a little more information?

MP-
 
C

Court1002

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.
 
M

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.
Click to expand...

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-
 
C

Court1002

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

Mangus Pyke

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


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-
 
Top