+ Reply to Thread
Results 1 to 13 of 13

Use a multiplier to change List Prices to Net prices

  1. #1
    Registered User
    Join Date
    07-06-2005
    Posts
    1

    Post Use a multiplier to change List Prices to Net prices

    Given a spread sheet showing "List" prices in a range of cells, how can one convert these prices to "net" prices when a multiplier is given by the vendor.

    In other words, I would like to multiply the contents of a column of cells by a multiplier located in the "discount" cell on the spreadsheet, thereby converting the "List" prices to "Net" prices.

    For instance, if list prices are located in cells a2:a40, I want to multiply each cell by a multiplier located in, say, cell b2



    Thanks

  2. #2
    Anne Troy
    Guest

    Re: Use a multiplier to change List Prices to Net prices

    Don't put the multiplier in B2. Instead, put it in C2. Then select C2 and
    hit Insert-->Name-->Define and call it markup. Then, in B2, put =A2*markup
    and copy that formula down to b40.

    You don't need to name cell C2, you can just put =A2*$C$2, but you can use
    "markup" anywhere you like without having to remember the cell it's in.
    *******************
    ~Anne Troy

    www.OfficeArticles.com
    www.MyExpertsOnline.com


    "Dangada" <[email protected]> wrote in
    message news:[email protected]...
    >
    > Given a spread sheet showing "List" prices in a range of cells, how can
    > one convert these prices to "net" prices when a multiplier is given by
    > the vendor.
    >
    > In other words, I would like to multiply the contents of a column of
    > cells by a multiplier located in the "discount" cell on the
    > spreadsheet, thereby converting the "List" prices to "Net" prices.
    >
    > For instance, if list prices are located in cells a2:a40, I want to
    > multiply each cell by a multiplier located in, say, cell b2
    >
    >
    >
    > Thanks
    >
    >
    > --
    > Dangada
    > ------------------------------------------------------------------------
    > Dangada's Profile:

    http://www.excelforum.com/member.php...o&userid=24940
    > View this thread: http://www.excelforum.com/showthread...hreadid=384760
    >




  3. #3
    Anne Troy
    Guest

    Re: Use a multiplier to change List Prices to Net prices

    Don't put the multiplier in B2. Instead, put it in C2. Then select C2 and
    hit Insert-->Name-->Define and call it markup. Then, in B2, put =A2*markup
    and copy that formula down to b40.

    You don't need to name cell C2, you can just put =A2*$C$2, but you can use
    "markup" anywhere you like without having to remember the cell it's in.
    *******************
    ~Anne Troy

    www.OfficeArticles.com
    www.MyExpertsOnline.com


    "Dangada" <[email protected]> wrote in
    message news:[email protected]...
    >
    > Given a spread sheet showing "List" prices in a range of cells, how can
    > one convert these prices to "net" prices when a multiplier is given by
    > the vendor.
    >
    > In other words, I would like to multiply the contents of a column of
    > cells by a multiplier located in the "discount" cell on the
    > spreadsheet, thereby converting the "List" prices to "Net" prices.
    >
    > For instance, if list prices are located in cells a2:a40, I want to
    > multiply each cell by a multiplier located in, say, cell b2
    >
    >
    >
    > Thanks
    >
    >
    > --
    > Dangada
    > ------------------------------------------------------------------------
    > Dangada's Profile:

    http://www.excelforum.com/member.php...o&userid=24940
    > View this thread: http://www.excelforum.com/showthread...hreadid=384760
    >




  4. #4
    Anne Troy
    Guest

    Re: Use a multiplier to change List Prices to Net prices

    Don't put the multiplier in B2. Instead, put it in C2. Then select C2 and
    hit Insert-->Name-->Define and call it markup. Then, in B2, put =A2*markup
    and copy that formula down to b40.

    You don't need to name cell C2, you can just put =A2*$C$2, but you can use
    "markup" anywhere you like without having to remember the cell it's in.
    *******************
    ~Anne Troy

    www.OfficeArticles.com
    www.MyExpertsOnline.com


    "Dangada" <[email protected]> wrote in
    message news:[email protected]...
    >
    > Given a spread sheet showing "List" prices in a range of cells, how can
    > one convert these prices to "net" prices when a multiplier is given by
    > the vendor.
    >
    > In other words, I would like to multiply the contents of a column of
    > cells by a multiplier located in the "discount" cell on the
    > spreadsheet, thereby converting the "List" prices to "Net" prices.
    >
    > For instance, if list prices are located in cells a2:a40, I want to
    > multiply each cell by a multiplier located in, say, cell b2
    >
    >
    >
    > Thanks
    >
    >
    > --
    > Dangada
    > ------------------------------------------------------------------------
    > Dangada's Profile:

    http://www.excelforum.com/member.php...o&userid=24940
    > View this thread: http://www.excelforum.com/showthread...hreadid=384760
    >




  5. #5
    Anne Troy
    Guest

    Re: Use a multiplier to change List Prices to Net prices

    Don't put the multiplier in B2. Instead, put it in C2. Then select C2 and
    hit Insert-->Name-->Define and call it markup. Then, in B2, put =A2*markup
    and copy that formula down to b40.

    You don't need to name cell C2, you can just put =A2*$C$2, but you can use
    "markup" anywhere you like without having to remember the cell it's in.
    *******************
    ~Anne Troy

    www.OfficeArticles.com
    www.MyExpertsOnline.com


    "Dangada" <[email protected]> wrote in
    message news:[email protected]...
    >
    > Given a spread sheet showing "List" prices in a range of cells, how can
    > one convert these prices to "net" prices when a multiplier is given by
    > the vendor.
    >
    > In other words, I would like to multiply the contents of a column of
    > cells by a multiplier located in the "discount" cell on the
    > spreadsheet, thereby converting the "List" prices to "Net" prices.
    >
    > For instance, if list prices are located in cells a2:a40, I want to
    > multiply each cell by a multiplier located in, say, cell b2
    >
    >
    >
    > Thanks
    >
    >
    > --
    > Dangada
    > ------------------------------------------------------------------------
    > Dangada's Profile:

    http://www.excelforum.com/member.php...o&userid=24940
    > View this thread: http://www.excelforum.com/showthread...hreadid=384760
    >




  6. #6
    Anne Troy
    Guest

    Re: Use a multiplier to change List Prices to Net prices

    Don't put the multiplier in B2. Instead, put it in C2. Then select C2 and
    hit Insert-->Name-->Define and call it markup. Then, in B2, put =A2*markup
    and copy that formula down to b40.

    You don't need to name cell C2, you can just put =A2*$C$2, but you can use
    "markup" anywhere you like without having to remember the cell it's in.
    *******************
    ~Anne Troy

    www.OfficeArticles.com
    www.MyExpertsOnline.com


    "Dangada" <[email protected]> wrote in
    message news:[email protected]...
    >
    > Given a spread sheet showing "List" prices in a range of cells, how can
    > one convert these prices to "net" prices when a multiplier is given by
    > the vendor.
    >
    > In other words, I would like to multiply the contents of a column of
    > cells by a multiplier located in the "discount" cell on the
    > spreadsheet, thereby converting the "List" prices to "Net" prices.
    >
    > For instance, if list prices are located in cells a2:a40, I want to
    > multiply each cell by a multiplier located in, say, cell b2
    >
    >
    >
    > Thanks
    >
    >
    > --
    > Dangada
    > ------------------------------------------------------------------------
    > Dangada's Profile:

    http://www.excelforum.com/member.php...o&userid=24940
    > View this thread: http://www.excelforum.com/showthread...hreadid=384760
    >




  7. #7
    Anne Troy
    Guest

    Re: Use a multiplier to change List Prices to Net prices

    Don't put the multiplier in B2. Instead, put it in C2. Then select C2 and
    hit Insert-->Name-->Define and call it markup. Then, in B2, put =A2*markup
    and copy that formula down to b40.

    You don't need to name cell C2, you can just put =A2*$C$2, but you can use
    "markup" anywhere you like without having to remember the cell it's in.
    *******************
    ~Anne Troy

    www.OfficeArticles.com
    www.MyExpertsOnline.com


    "Dangada" <[email protected]> wrote in
    message news:[email protected]...
    >
    > Given a spread sheet showing "List" prices in a range of cells, how can
    > one convert these prices to "net" prices when a multiplier is given by
    > the vendor.
    >
    > In other words, I would like to multiply the contents of a column of
    > cells by a multiplier located in the "discount" cell on the
    > spreadsheet, thereby converting the "List" prices to "Net" prices.
    >
    > For instance, if list prices are located in cells a2:a40, I want to
    > multiply each cell by a multiplier located in, say, cell b2
    >
    >
    >
    > Thanks
    >
    >
    > --
    > Dangada
    > ------------------------------------------------------------------------
    > Dangada's Profile:

    http://www.excelforum.com/member.php...o&userid=24940
    > View this thread: http://www.excelforum.com/showthread...hreadid=384760
    >




  8. #8
    Anne Troy
    Guest

    Re: Use a multiplier to change List Prices to Net prices

    Don't put the multiplier in B2. Instead, put it in C2. Then select C2 and
    hit Insert-->Name-->Define and call it markup. Then, in B2, put =A2*markup
    and copy that formula down to b40.

    You don't need to name cell C2, you can just put =A2*$C$2, but you can use
    "markup" anywhere you like without having to remember the cell it's in.
    *******************
    ~Anne Troy

    www.OfficeArticles.com
    www.MyExpertsOnline.com


    "Dangada" <[email protected]> wrote in
    message news:[email protected]...
    >
    > Given a spread sheet showing "List" prices in a range of cells, how can
    > one convert these prices to "net" prices when a multiplier is given by
    > the vendor.
    >
    > In other words, I would like to multiply the contents of a column of
    > cells by a multiplier located in the "discount" cell on the
    > spreadsheet, thereby converting the "List" prices to "Net" prices.
    >
    > For instance, if list prices are located in cells a2:a40, I want to
    > multiply each cell by a multiplier located in, say, cell b2
    >
    >
    >
    > Thanks
    >
    >
    > --
    > Dangada
    > ------------------------------------------------------------------------
    > Dangada's Profile:

    http://www.excelforum.com/member.php...o&userid=24940
    > View this thread: http://www.excelforum.com/showthread...hreadid=384760
    >




  9. #9
    Anne Troy
    Guest

    Re: Use a multiplier to change List Prices to Net prices

    Don't put the multiplier in B2. Instead, put it in C2. Then select C2 and
    hit Insert-->Name-->Define and call it markup. Then, in B2, put =A2*markup
    and copy that formula down to b40.

    You don't need to name cell C2, you can just put =A2*$C$2, but you can use
    "markup" anywhere you like without having to remember the cell it's in.
    *******************
    ~Anne Troy

    www.OfficeArticles.com
    www.MyExpertsOnline.com


    "Dangada" <[email protected]> wrote in
    message news:[email protected]...
    >
    > Given a spread sheet showing "List" prices in a range of cells, how can
    > one convert these prices to "net" prices when a multiplier is given by
    > the vendor.
    >
    > In other words, I would like to multiply the contents of a column of
    > cells by a multiplier located in the "discount" cell on the
    > spreadsheet, thereby converting the "List" prices to "Net" prices.
    >
    > For instance, if list prices are located in cells a2:a40, I want to
    > multiply each cell by a multiplier located in, say, cell b2
    >
    >
    >
    > Thanks
    >
    >
    > --
    > Dangada
    > ------------------------------------------------------------------------
    > Dangada's Profile:

    http://www.excelforum.com/member.php...o&userid=24940
    > View this thread: http://www.excelforum.com/showthread...hreadid=384760
    >




  10. #10
    Anne Troy
    Guest

    Re: Use a multiplier to change List Prices to Net prices

    Don't put the multiplier in B2. Instead, put it in C2. Then select C2 and
    hit Insert-->Name-->Define and call it markup. Then, in B2, put =A2*markup
    and copy that formula down to b40.

    You don't need to name cell C2, you can just put =A2*$C$2, but you can use
    "markup" anywhere you like without having to remember the cell it's in.
    *******************
    ~Anne Troy

    www.OfficeArticles.com
    www.MyExpertsOnline.com


    "Dangada" <[email protected]> wrote in
    message news:[email protected]...
    >
    > Given a spread sheet showing "List" prices in a range of cells, how can
    > one convert these prices to "net" prices when a multiplier is given by
    > the vendor.
    >
    > In other words, I would like to multiply the contents of a column of
    > cells by a multiplier located in the "discount" cell on the
    > spreadsheet, thereby converting the "List" prices to "Net" prices.
    >
    > For instance, if list prices are located in cells a2:a40, I want to
    > multiply each cell by a multiplier located in, say, cell b2
    >
    >
    >
    > Thanks
    >
    >
    > --
    > Dangada
    > ------------------------------------------------------------------------
    > Dangada's Profile:

    http://www.excelforum.com/member.php...o&userid=24940
    > View this thread: http://www.excelforum.com/showthread...hreadid=384760
    >




  11. #11
    Anne Troy
    Guest

    Re: Use a multiplier to change List Prices to Net prices

    Don't put the multiplier in B2. Instead, put it in C2. Then select C2 and
    hit Insert-->Name-->Define and call it markup. Then, in B2, put =A2*markup
    and copy that formula down to b40.

    You don't need to name cell C2, you can just put =A2*$C$2, but you can use
    "markup" anywhere you like without having to remember the cell it's in.
    *******************
    ~Anne Troy

    www.OfficeArticles.com
    www.MyExpertsOnline.com


    "Dangada" <[email protected]> wrote in
    message news:[email protected]...
    >
    > Given a spread sheet showing "List" prices in a range of cells, how can
    > one convert these prices to "net" prices when a multiplier is given by
    > the vendor.
    >
    > In other words, I would like to multiply the contents of a column of
    > cells by a multiplier located in the "discount" cell on the
    > spreadsheet, thereby converting the "List" prices to "Net" prices.
    >
    > For instance, if list prices are located in cells a2:a40, I want to
    > multiply each cell by a multiplier located in, say, cell b2
    >
    >
    >
    > Thanks
    >
    >
    > --
    > Dangada
    > ------------------------------------------------------------------------
    > Dangada's Profile:

    http://www.excelforum.com/member.php...o&userid=24940
    > View this thread: http://www.excelforum.com/showthread...hreadid=384760
    >




  12. #12
    Anne Troy
    Guest

    Re: Use a multiplier to change List Prices to Net prices

    Don't put the multiplier in B2. Instead, put it in C2. Then select C2 and
    hit Insert-->Name-->Define and call it markup. Then, in B2, put =A2*markup
    and copy that formula down to b40.

    You don't need to name cell C2, you can just put =A2*$C$2, but you can use
    "markup" anywhere you like without having to remember the cell it's in.
    *******************
    ~Anne Troy

    www.OfficeArticles.com
    www.MyExpertsOnline.com


    "Dangada" <[email protected]> wrote in
    message news:[email protected]...
    >
    > Given a spread sheet showing "List" prices in a range of cells, how can
    > one convert these prices to "net" prices when a multiplier is given by
    > the vendor.
    >
    > In other words, I would like to multiply the contents of a column of
    > cells by a multiplier located in the "discount" cell on the
    > spreadsheet, thereby converting the "List" prices to "Net" prices.
    >
    > For instance, if list prices are located in cells a2:a40, I want to
    > multiply each cell by a multiplier located in, say, cell b2
    >
    >
    >
    > Thanks
    >
    >
    > --
    > Dangada
    > ------------------------------------------------------------------------
    > Dangada's Profile:

    http://www.excelforum.com/member.php...o&userid=24940
    > View this thread: http://www.excelforum.com/showthread...hreadid=384760
    >




  13. #13
    Anne Troy
    Guest

    Re: Use a multiplier to change List Prices to Net prices

    Don't put the multiplier in B2. Instead, put it in C2. Then select C2 and
    hit Insert-->Name-->Define and call it markup. Then, in B2, put =A2*markup
    and copy that formula down to b40.

    You don't need to name cell C2, you can just put =A2*$C$2, but you can use
    "markup" anywhere you like without having to remember the cell it's in.
    *******************
    ~Anne Troy

    www.OfficeArticles.com
    www.MyExpertsOnline.com


    "Dangada" <[email protected]> wrote in
    message news:[email protected]...
    >
    > Given a spread sheet showing "List" prices in a range of cells, how can
    > one convert these prices to "net" prices when a multiplier is given by
    > the vendor.
    >
    > In other words, I would like to multiply the contents of a column of
    > cells by a multiplier located in the "discount" cell on the
    > spreadsheet, thereby converting the "List" prices to "Net" prices.
    >
    > For instance, if list prices are located in cells a2:a40, I want to
    > multiply each cell by a multiplier located in, say, cell b2
    >
    >
    >
    > Thanks
    >
    >
    > --
    > Dangada
    > ------------------------------------------------------------------------
    > Dangada's Profile:

    http://www.excelforum.com/member.php...o&userid=24940
    > View this thread: http://www.excelforum.com/showthread...hreadid=384760
    >




+ 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