Excel Formula
 

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

On Tue, 26 Jul 2005 18:18:03 -0700, Court1002 wrote:
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-

--
"Learning is a behavior that results from consequences."
B.F. Skinner

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" wrote:

On Tue, 26 Jul 2005 18:18:03 -0700, Court1002 wrote:
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-

--
"Learning is a behavior that results from consequences."
B.F. Skinner

On Tue, 26 Jul 2005 18:35:02 -0700, Court1002 wrote:
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-
--
"Learning is a behavior that results from consequences."
B.F. Skinner

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

"Mangus Pyke" wrote:

On Tue, 26 Jul 2005 18:35:02 -0700, Court1002 wrote:
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-
--
"Learning is a behavior that results from consequences."
B.F. Skinner

On Tue, 26 Jul 2005 18:50:01 -0700, Court1002 wrote:
I'm doing this for my grandfather's radiator shop, but I'm going to say the
mean price

On Tue, 26 Jul 2005 18:35:02 -0700, Court1002 wrote:
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.


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-
--
"Learning is a behavior that results from consequences."
B.F. Skinner

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

"Mangus Pyke" wrote:

On Tue, 26 Jul 2005 18:50:01 -0700, Court1002 wrote:
I'm doing this for my grandfather's radiator shop, but I'm going to say the
mean price

On Tue, 26 Jul 2005 18:35:02 -0700, Court1002 wrote:
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.


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-
--
"Learning is a behavior that results from consequences."
B.F. Skinner