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