I have a row with numbers A1-1, B1-2, C1-3, D1-4 and in A2-3.
Is it possible to multiply all numbers in row with A2 number automatically
or some formula?

Thank you!

Peter

Hi Peter,

Your post isn't very clear.
In your example.

You can copy A2
Select A1 to D1
Right click on the selection
Pick Paste Special
Check multiply
And OK out.

That does what you seem to be saying but I suspect
you are trying something beyond that.


HTH
Martin

"Lion2004" wrote in message
...
I have a row with numbers A1-1, B1-2, C1-3, D1-4 and in A2-3.
Is it possible to multiply all numbers in row with A2 number automatically
or some formula?

Thank you!

Peter

Maybe copy n paste special multiply ?
Copy A2. Select the range A1:D1, right-click paste special check
multiply ok
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Lion2004" wrote:
I have a row with numbers A1-1, B1-2, C1-3, D1-4 and in A2-3.
Is it possible to multiply all numbers in row with A2 number automatically
or some formula?

Thank you!

Peter

By formula:
=A1*$A2 and copy across the 4 columns.

Alternatively, if you want to change the existing values in row 1, select
A2, copy, select A1 to D1, Edit/ Paste Special/ Multiply.
--
David Biddulph

"Lion2004" wrote in message
...
I have a row with numbers A1-1, B1-2, C1-3, D1-4 and in A2-3.
Is it possible to multiply all numbers in row with A2 number automatically
or some formula?

Thank you!

Peter

Thank you David Biddulph!
It was exacly what i needed.

Kind regards,

Peter

"David Biddulph" wrote:

By formula:
=A1*$A2 and copy across the 4 columns.

Alternatively, if you want to change the existing values in row 1, select
A2, copy, select A1 to D1, Edit/ Paste Special/ Multiply.
--
David Biddulph

"Lion2004" wrote in message
...
I have a row with numbers A1-1, B1-2, C1-3, D1-4 and in A2-3.
Is it possible to multiply all numbers in row with A2 number automatically
or some formula?

Thank you!

Peter