Multiply a co;omn by a constant

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?
 
S

Stan Brown

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

Calculating column A * column B = Results in another column 2
Page numbering with Merged Document and IF statements 1
Best (Easiest) to Multiply Columns by a Constant? 7
Advance Sumproduct calculation 8
HOW DO I MULTIPLY MANY CELLS BY A CONSTANT CELL ? 12
Count with 1 variable & 1 constant criteria formula 3
Argument help - amounts in different rows divided by a constant 2
Would like one cell to both count and multiply a range of cells 2

Top