How do I create a formula repeated on the adjacentt columns?
If you want to multiply A3 by B3, then in C3 type: =A3*B3
and copy down as previously described!
If you require anything other than this, I suggest you try to
explain exactly what it is that you want, in more detail.
Also it would be prudent to use a *copy* of your workbook
to try anything new.
George Gee
"Excelless" wrote in message
...
But how do I create the formula itself? This just overwrote all the
previous
data cells with the top cell's value - thx.
"Excelless" wrote:
I am trying to make the same operation for each column - the only
difference
is in the rows, e.g.
C3=A3*B*
C4=A4*B4, etc.
I don't want to have to re-enter a similar formula for each added row.
Thanks.
|