current row in formula

  • Thread starter Thread starter willemeulen
  • Start date Start date
W

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
 
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
 
Back
Top