multiplying the existing cell values

  • Thread starter Thread starter m.balraj
  • Start date Start date
M

m.balraj

Hi,

I'm working on a budget & inadvertantly entered all the data to i
before including the inflationary factor. Since the file is too big i
there a simple way to multiply all the exisiting figures in the cell
by a given inflationary factor.Further,the matter is bit mor
complicated because my boss wants a formula to be used so that an
future changes to the inflationary factor will automatically update th
data in the cells.


Regards,

Ra
 
Hi
try the following:
- enter your factor in an empty cell
- copy this cell
- select the cells which should be changed
- goto 'Edit - Paste Special' and choose 'Multiply'
 
Back
Top