+ Reply to Thread
Results 1 to 19 of 19

Excel Formula-different products from different suppliers.

  1. #1
    Mangus Pyke
    Guest

    Excel Formula-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

  2. #2
    Court1002
    Guest

    re: Excel Formula-different products from different suppliers.

    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
    >


  3. #3
    Mangus Pyke
    Guest

    re: Excel Formula-different products from different suppliers.

    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

  4. #4
    Court1002
    Guest

    re: Excel Formula-different products from different suppliers.

    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
    >


  5. #5
    Mangus Pyke
    Guest

    re: Excel Formula-different products from different suppliers.

    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

  6. #6
    Court1002
    Guest

    re: Excel Formula-different products from different suppliers.

    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
    >


  7. #7
    Court1002
    Guest

    re: Excel Formula-different products from different suppliers.

    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
    >


  8. #8
    Mangus Pyke
    Guest

    re: Excel Formula-different products from different suppliers.

    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

  9. #9
    Court1002
    Guest

    re: Excel Formula-different products from different suppliers.

    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
    >


  10. #10
    Mangus Pyke
    Guest

    re: Excel Formula-different products from different suppliers.

    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

  11. #11
    Court1002
    Guest

    re: Excel Formula-different products from different suppliers.

    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
    >


  12. #12
    Mangus Pyke
    Guest

    re: Excel Formula-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

  13. #13
    Court1002
    Guest

    re: Excel Formula-different products from different suppliers.

    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
    >


  14. #14
    Mangus Pyke
    Guest

    re: Excel Formula-different products from different suppliers.

    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

  15. #15
    Court1002
    Guest

    re: Excel Formula-different products from different suppliers.

    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
    >


  16. #16
    Mangus Pyke
    Guest

    re: Excel Formula-different products from different suppliers.

    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

  17. #17
    Court1002
    Guest

    re: Excel Formula-different products from different suppliers.

    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
    >


  18. #18
    Mangus Pyke
    Guest

    re: Excel Formula-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

  19. #19
    Court1002
    Guest

    Excel Formula

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

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1