Use a multiplier to change List Prices to Net prices

[Dangada]

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

 

[Anne Troy]

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