Thanks:  0
Likes:  0

# Thread: I need help with a SIMPLE equation, don't laugh too hard.

1. 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.

2. 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.

Hi Tarak

If I understand you correctly,yoo have problems with the @sum(function)

garethl@ij.co.za

3. 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.

4. 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.
that should be okay :

=A1*.03937 would work fine

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 ]

## User Tag List

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•