Adding Formula to Existing Cells

P

paige

In Excel, I have a column with various numbers in each
row. I want to multiple each number by 1.02. Short of
doing this with extra columns, is there a way to use
find/replace and add *1.02 to whatever is already existing
in each cell?
 
C

Chip Pearson

Paige,

Enter 1.02 in some blank cell and copy that cell. Then select the number
you want to multiply by 1.02. Go to the Edit menu, choose Paste Special,
and choose the Multiply operation.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com [email protected]
 
P

PAIGE

THANK YOU THANK YOU!!!!!
-----Original Message-----
Paige,

Enter 1.02 in some blank cell and copy that cell. Then select the number
you want to multiply by 1.02. Go to the Edit menu, choose Paste Special,
and choose the Multiply operation.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com [email protected]






.
Click to expand...
 
Top