Thread: Excel Formula
View Single Post
  #5   Report Post  
Court1002
 
Posts: n/a
Default

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