software

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: www.excelforum.com/member.php...oamp;userid=32957
View this thread: www.excelforum.com/showthread...hreadid=527898One way:

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

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
quot;true_atlantisquot; gt;
wrote in message
news:true_atlantis.25gl7y_1143682200.8669@excelfor um-nospam.com...
gt;
gt; i know that ROW() gives me the current row, but lets say i want to
gt; select the cell at column B on the current ROW and devide that by the
gt; cell at column D on the current ROW. how would i select these specific
gt; cells?
gt;
gt;
gt; --
gt; true_atlantis
gt; ------------------------------------------------------------------------
gt; true_atlantis's Profile:
www.excelforum.com/member.php...oamp;userid=32957
gt; View this thread: www.excelforum.com/showthread...hreadid=527898
gt;The normal way woud be, if ROW is #8, =B8/D8 That is. divided B8 by
D8.The normal way woud be, if ROW is #8, =B8/D8 That is. divided B8 by
D8.

ed