G Guest Aug 1, 2007 #1 Can I multiply wholesale pricing by a multiplier to mark-up to retail prices? Or does each item need to be adjusted one by one?
Can I multiply wholesale pricing by a multiplier to mark-up to retail prices? Or does each item need to be adjusted one by one?
G Guest Aug 1, 2007 #2 Put the mutiplier in a spare cell and COPY Highlight prices to be uplifted Paste Special==>Operation=>Multiply Prices will be uplifted delete Multiplier cell
Put the mutiplier in a spare cell and COPY Highlight prices to be uplifted Paste Special==>Operation=>Multiply Prices will be uplifted delete Multiplier cell
L L. Howard Kittle Aug 1, 2007 #3 In a cell enter your value add or multiply, copy it, select the values and under Edit > Paste Special > Add or Multiply >OK. HTH Regards, Howard
In a cell enter your value add or multiply, copy it, select the values and under Edit > Paste Special > Add or Multiply >OK. HTH Regards, Howard
B Bob I Aug 1, 2007 #4 Usually you need a column for wholesale, and a column for retail. You can multiple everything by a common multiplier using Copy, Paste Special, Multiply
Usually you need a column for wholesale, and a column for retail. You can multiple everything by a common multiplier using Copy, Paste Special, Multiply
