Multiplying in a row
 

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

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.


--
tj


"Daniel - Sydney" wrote:

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

Thanks for your help

Daniel

"tjtjjtjt" wrote:

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.


--
tj


"Daniel - Sydney" wrote:

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

Enter .3 in an unused cell.

Select and copy.

Select A4:W4 and Paste SpecialMultiplyOkEsc.


Gord Dibben Excel MVP

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

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