Results 1 to 6 of 6
  1. #1
    Lounger
    Join Date
    Jan 2001
    Location
    Bay Area, California, USA
    Posts
    29
    Thanks
    0
    Thanked 0 Times in 0 Posts

    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. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    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. #3
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    2,826
    Thanks
    136
    Thanked 482 Times in 459 Posts

    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. #4
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    2,826
    Thanks
    136
    Thanked 482 Times in 459 Posts

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

    I like your answer better!!!

    Thanks for the inside info!

    zeddy

  5. #5
    Lounger
    Join Date
    Jan 2001
    Location
    Bay Area, California, USA
    Posts
    29
    Thanks
    0
    Thanked 0 Times in 0 Posts

    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. #6
    Lounger
    Join Date
    Jan 2001
    Location
    Bay Area, California, USA
    Posts
    29
    Thanks
    0
    Thanked 0 Times in 0 Posts

    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
  •