×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Howto multiply all cells in array IN PLACE (not referenced)?

Howto multiply all cells in array IN PLACE (not referenced)?

Howto multiply all cells in array IN PLACE (not referenced)?

(OP)
I'm using Gnumeric and other open-source spreadsheets.
What would be the general procedure to multiply all cells by a constant?

My array is A1:ES80 and I want to multiply all by 10.  I know I can select a new area of the same size and type =A1:ES80 * 10, Ctrl-Shift-Enter.  However then the new array is referenced to the original, and can't be easily saved.  I would like to just multiply the original array.
Thanks!

RE: Howto multiply all cells in array IN PLACE (not referenced)?

In Excel ASAP utilities can do this for you. Otherwise, often you can replace something common to your cell entries by =10* to get what you want. Other than that, I don't see any other option than calculating as you described, then copy/paste values - assuming this exists in Gnumeric.

Cheers,
Joerd

Please see FAQ731-376 for tips on how to make the best use of Eng-Tips.

RE: Howto multiply all cells in array IN PLACE (not referenced)?

(OP)
Thanks for the reply.

I've tried all types of =10*, =A1*10, =indirect(a1)*10 and can't seem to modify the cell contents.  I keep getting invalid expression, or 0 for the answer.

Copy/paste would be fine too, but the new/multiplied array is still referenced to the first.  Is there a way to make static numbers?

RE: Howto multiply all cells in array IN PLACE (not referenced)?

(OP)
OK, I found the Paste-Special menu, which allows me to paste as a value (not linked) or even to multiply the source by the destination value!

Thanks for the help.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources