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
Bookmarks