Multiply a co;omn by a constant

  • Thread starter Thread starter Q
  • Start date Start date
Q

Q

It appears Excel is very powerful at performing funtions on arrays, however,
I simply want to multiply a whole column of numbers by one constant number,
and get the result either in the same column (for each individual number), or
the next column. It appears that excel does not have this capability. Is
there a program that does?
 
Sat said:
It appears Excel is very powerful at performing funtions on arrays, however,
I simply want to multiply a whole column of numbers by one constant number,
and get the result either in the same column (for each individual number), or
the next column. It appears that excel does not have this capability. Is
there a program that does?
Click to expand...

Yes, and it's called Excel. Use Edit | Paste Special, and specify
"Values" and "Multiply.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I multiply ALL CELL in spreadsheet at once by .5 ? 4
Function usage and outcome clarification 14
Calculating column A * column B = Results in another column 2
Reverse SumProduct function 18
constant multiplier 4
Adding Columns with Multipliers 4
Advance Sumproduct calculation 8
how to create a repeat formula using the same multiplier? 2

Back
Top