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

:confused:

Thanks


--
Dangada
------------------------------------------------------------------------
Dangada's Profile: http://www.excelforum.com/member.php...o&userid=24940
View this thread: http://www.excelforum.com/showthread...hreadid=384760

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" wrote in
message ...

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

:confused:

Thanks


--
Dangada
------------------------------------------------------------------------
Dangada's Profile:
http://www.excelforum.com/member.php...o&userid=24940
View this thread: http://www.excelforum.com/showthread...hreadid=384760