simple equation

[true_atlantis]

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

 

[Ragdyer]

One way:

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

 

[edcosoft]

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

 

[edcosoft]

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

ed