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