Thread: multiply each value in a range (2000 SR1)

1. multiply each value in a range (2000 SR1)

I have a range of values, say A1-F6. I want to multiply all the values in that range with the same multiplier, but want the results to replace the original values in the same range.

If I select the range, type =*1.5 (in A1) and press Ctrl-Enter, I replace all the values in the range with =1.5, instead of the result I want.

If I select the range, type =A1*1.5 and press Ctrl-Enter, I create a circular reference. Although all cells now display =A1*1.5 through =F6*1.5 in the formula bar, the result in each cell is 0, which I understand.

I tried using =value(A1*1.5) etc, but no luck.

Any idea if this can be done in one step, or do I have to do this in another range, then move the result to the original range as values?

Thanks

2. Re: multiply each value in a range (2000 SR1)

Enter 1.5 in any cell. Copy it to the clipboard.

Select the range you want to manipulate, do Edit, PasteSpecial and select Multiply.

Andrew C

3. Re: multiply each value in a range (2000 SR1)

Looks like a bit of matrix math to me.

If you goto an empty cell, say [k1] type
=1.5*a1:f6
and then press Ctrl-Shift-Enter
You'll see a single result.
Now select the cell with this result.
Press [F2] for Edit and then immediately press
[F9] - look in the top panel and you'll see an array of all your values multiplied by your factor
Any use???

zeddy

4. Re: multiply each value in a range (2000 SR1)

Thanks for the inside info!

zeddy

5. Re: multiply each value in a range (2000 SR1)

Hah! I love it - very sweet indeed [img]/forums/images/smilies/smile.gif[/img]

Thank you very much,

Klaus

6. Re: multiply each value in a range (2000 SR1)

Hey zeddy,

that Matrix-bit was pretty good.
U never know when that comes in handy, I'll keep that one around for future reference...

Thanks,
Klaus

Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•