Please be patient,I'm obviously a beginner, I managed to multiply a cell x.03937, but how do I use the same formula for heaps of cells?
I think it's the way I'm multiplying.
Thanks in advance.
Please be patient,I'm obviously a beginner, I managed to multiply a cell x.03937, but how do I use the same formula for heaps of cells?
I think it's the way I'm multiplying.
Thanks in advance.
Hi Tarak
If I understand you correctly,yoo have problems with the @sum(function)
On 2002-05-06 04:59, Tarak wrote:
See that's how much of a beginner I am, I was just putting *.03937 in another cell and then telling the cell I want to multiply.
1) hit "="
2) click your mouse on cell A1
3) hit "*"
4) key in ".03937"
5) hit enter
to repeat this logic for other cells, goto the cell with this new formula, hit "CNTRL" and "C" (this copies) then goto to your new destination cell and hit "CNTRL" and "V" (this pastes)
goto another new cell and hit "CNTRL" and "V" (this pastes)..... repeating for new cells as needed
If your formula is needed in a range of cells which are all next to each other (contiguous) then just "drag" it down as follows :
hovver your mouse over the cell with the formula in it..... move the mouse so it sits over the bottom right corner : your cursor should change to a black "+" sign
left click and drag down/up/over as needed
Hope this helps
Chris
This message was edited by Chris Davison on 2002-05-06 06:03
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.