simple equation
 

i know that ROW() gives me the current row, but lets say i want to
select the cell at column B on the current ROW and devide that by the
cell at column D on the current ROW. how would i select these specific
cells?


--
true_atlantis
------------------------------------------------------------------------
true_atlantis's Profile: http://www.excelforum.com/member.php...o&userid=32957
View this thread: http://www.excelforum.com/showthread...hreadid=527898

simple equation
 

One way:

=INDEX(B:B,ROW())/INDEX(D:D,ROW())

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"true_atlantis"
wrote in message
news:true_atlantis.25gl7y_1143682200.8669@excelfor um-nospam.com...

i know that ROW() gives me the current row, but lets say i want to
select the cell at column B on the current ROW and devide that by the
cell at column D on the current ROW. how would i select these specific
cells?


--
true_atlantis
------------------------------------------------------------------------
true_atlantis's Profile:
http://www.excelforum.com/member.php...o&userid=32957
View this thread: http://www.excelforum.com/showthread...hreadid=527898

simple equation
 

The normal way woud be, if ROW is #8, =B8/D8 That is. divided B8 by
D8.

simple equation
 

The normal way woud be, if ROW is #8, =B8/D8 That is. divided B8 by
D8.

ed