how can prices be changed by one multiplier?

J

Julia Ezra

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?
 
T

Toppers

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

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

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
 
Top