View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Toppers Toppers is offline
external usenet poster
 
Posts: 4,339
Default how can prices be changed by one multiplier?

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

"Julia Ezra" wrote:

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?