How do I use a reffer to a current row in formula

Example:

A1*B1/C1

A&Row()*B&Row()/C&Row

The example above doesent work but want column to be fixed and row depending
on the row it's actully is current. I want to formula to be working when I
copy it from one sheet to the other.


Cheers,

w

=INDIRECT("A"&ROW())*INDIRECT("B"&ROW())/INDIRECT("C"&ROW())
--
David Biddulph

"willemeulen" wrote in message
...
How do I use a reffer to a current row in formula

Example:

A1*B1/C1

A&Row()*B&Row()/C&Row

The example above doesent work but want column to be fixed and row
depending
on the row it's actully is current. I want to formula to be working when I
copy it from one sheet to the other.


Cheers,

w

If you copy that formula to the same column in another sheet, but in,
say, row 5, it will adjust itself to:

=A5*B5/C5

so what's the problem?

If you want it in another column, but still want the formula to refer
to column A, B and C, then write it like this:

=$A1*$B1/$C1

Hope this helps.

Pete


On Dec 7, 1:53*pm, willemeulen
wrote:
How do I use a reffer to a current row in formula

Example:

A1*B1/C1

A&Row()*B&Row()/C&Row

The example above doesent work but want column to be fixed and row depending
on the row it's actully is current. I want to formula to be working when I
copy it from one sheet to the other.

Cheers,

w

If I understood you correctly - try this out:
=INDIRECT("A"&ROW())*INDIRECT("B"&ROW())/INDIRECT("C"&ROW())
Micky


"willemeulen" wrote:

How do I use a reffer to a current row in formula

Example:

A1*B1/C1

A&Row()*B&Row()/C&Row

The example above doesent work but want column to be fixed and row depending
on the row it's actully is current. I want to formula to be working when I
copy it from one sheet to the other.


Cheers,

w