current row in formula

[willemeulen]

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

 

[David Biddulph]

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

 

[Pete_UK]

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

 

[מיכ×ל (מיקי) ×בידן]

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