Multiplying a cell and displaying the result in the same cell

R

robspot

Hi

Is it possible to perform a calculation on a cell (well a column) an
replace the data in the cell with the result? I have a spreadshee
which uploads data to a database (not sure which type - it's
mechanical estimating package) and I need to increase the price colum
by a certain percentage. I cannot add or delete any of the column
otherwise the upload won't work.

Thanks
Ro
 
F

Frank Kabel

Hi
try:
- enter your multiplication factor in an empty cell (e.g. 1.1)
- copy this cell
- select your imported data
- goto 'Edit - Paste Special' and choose 'Multiply
 
Top