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!
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)?
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)?
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)?
Thanks for the help.