Formula Question
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
DonnaS wrote:
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
|