Multiplying in a row

D

Daniel - Sydney

Hi

I need to multiply a row of numbers by 30%,
the row extends from A4 to W4.

How do I do it.

thanks

Daniel
 
T

tjtjjtjt

You want A4:W4 to be 130% of their curretn values?
Type 1.3 in a cell.
Then, copy that cell.
Select A4:W4.
Go to Edit | Paste Special. Choose Multiply and click Okay.
 
D

Daniel - Sydney

Thanks for your help

Daniel

tjtjjtjt said:
You want A4:W4 to be 130% of their curretn values?
Type 1.3 in a cell.
Then, copy that cell.
Select A4:W4.
Go to Edit | Paste Special. Choose Multiply and click Okay.
Click to expand...
 
G

Gord Dibben

Enter .3 in an unused cell.

Select and copy.

Select A4:W4 and Paste Special>Multiply>Ok>Esc.


Gord Dibben Excel MVP

On Mon, 26 Sep 2005 16:05:02 -0700, Daniel - Sydney <Daniel -
 
Top