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.
 
Back
Top