| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to multiply all cells in array by factor
I have an array from A1:ES80 which I want to multiply all cells by 10. I know I can select another area on the spreadsheet of the same size, enter =A1:ES80*10 and press CTL-Shift-Enter to have a new array created. Unfortunately, this new array is now referenced to the first, and doesn't let me save just this new array (I am using CSV format so I can open in graphing/plotting programs). Is there a way to multiply the original array so i can easily save it? Thanks! -- rhauff ------------------------------------------------------------------------ rhauff's Profile: http://www.excelforum.com/member.php...o&userid=32644 View this thread: http://www.excelforum.com/showthread...hreadid=524507 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Would like one cell to both count and multiply a range of cells | Excel Worksheet Functions | |||
| Count if array contains cells of a certain value | Excel Worksheet Functions | |||
| How do I correctly multiply rounded cells in Excel? | Excel Worksheet Functions | |||
| To safety merge cells without data destroyed, and smart unmerge! | Excel Discussion (Misc queries) | |||
| Heps to design Locked/Unlocked cells in protected worksheet | Excel Discussion (Misc queries) | |||
Threaded Mode
