Formula Question

[Guest]

Greetings - The following is an example of what I want to do. I want to
take all of these figures times 160 and have the result display in the cell
instead. I have only come up with creating a manual formula in each cell
such as =0.1*160 but prefer to have something more automated as there are a
couple hundred of these cells. Thank you for your kind assistance.

Col A Col B Col C
0.1 0.1 0.1
0.5 0.5 0.5
0.05 0.05 0.05
0.25 0.25 0.25
0.1 0.1 0.1

 

[Pete_UK]

Enter the value 160 in a blank cell somewhere - select this cell and
click <copy>. Then highlight all the cells in columns A to C which
contain values which you want to change then Edit | Paste Special |
Multiply (check in Operations section) then OK followed by <Esc>. This
will multiply every highlighted value by 160 - you can delete the
original cell.

Hope this helps.

Pete

 

[Guest]

=SUM(RANGE)*160 where RANGE is the range of cells you want to multiply by 160.

Example: if your data is in range A1:C10000, then =SUM(A1:C10000)*160 would
multiply all values in that range by 160.

Dave

 

[Guest]

Well i don't know what you really want but as my underestanding you have to
do as follow:

Col A Col B Col C Col D Col E Col F
1 0.1 0.1 0.1 =A1*160
2 0.5 0.5 0.5
3 0.05 0.05 0.05
4 0.25 0.25 0.25
5 0.1 0.1 0.1

and then copy the formula in the cell D1 as follow:

active cell D1
pu the mouse on the right bottomn corner of the active cell
hit the mouse left bottomn and keep it
drag mouse to column E & F and then drag down to where ever you want
leave the mouse left bottomn
now the formula has copied to all cells and the cells are selected
after that right click on the selected cells and choos copy
then right click on cell A1 and choos past especial and then choos value and
the click ok so now all figurs have replaced with the rusult

hope it works

 

[Guest]

Thanks! That is exactly what I needed.
You guys that help the lost rock!