| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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... |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| HOW DO I MULTIPLY MANY CELLS BY A CONSTANT CELL ? | Excel Discussion (Misc queries) | |||
| is it possible to multiply whole of excel table by some constant | Excel Discussion (Misc queries) | |||
| Need Help Creating a Macro to Multiply Cells by a Constant Number | Excel Discussion (Misc queries) | |||
| can i multiply digits of a number by a constant in excel? | Excel Discussion (Misc queries) | |||
| Multiply by a constant | Excel Discussion (Misc queries) | |||
Linear Mode
