Thread: formula?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
pinmaster pinmaster is offline
external usenet poster
 
Posts: 347
Default formula?

Hi,

Let's say you want to increase the values in A1:A100 by 25%. In a blank cell
type 1.25 and copy that cell, next select A1:A100 and do a Paste Special -
Multiply.

HTH
Jean-Guy

"jonilyn" wrote:

What's the best way to increase a whole series of numbers by the same
percentage? Usually all in one column. Thank you.