Multiply a co;omn by a constant
 

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?

Multiply a co;omn by a constant
 

Sat, 20 Feb 2010 12:42:01 -0800 from 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?

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

--
Stan Brown, Oak Road Systems, Tompkins County, New York, USA
http://OakRoadSystems.com
Shikata ga nai...

Multiply a co;omn by a constant
 

See this...

http://contextures.com/xlDataEntry04.html

--
Biff
Microsoft Excel MVP


"Q" wrote in message
...
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?