W
Wim Goelen
Hi,
is there a way to retrieve the rownumber of the cell that "has the focus"? I
would like to calculate a number of values in the top row, but the formulas
need the rownumber to look up the correct prices.
In the formula below, the cell will contain a value of 50, 20 or zero,
depending on where the user's cursor is placed, the rownumber is then put in
D5
=IF(INDIRECT(CONCATENATE("H";D5))>0;50;IF(INDIRECT(CONCATENATE("L";D5))>0;20;0))
Thanks,
Wim Goelen
is there a way to retrieve the rownumber of the cell that "has the focus"? I
would like to calculate a number of values in the top row, but the formulas
need the rownumber to look up the correct prices.
In the formula below, the cell will contain a value of 50, 20 or zero,
depending on where the user's cursor is placed, the rownumber is then put in
D5
=IF(INDIRECT(CONCATENATE("H";D5))>0;50;IF(INDIRECT(CONCATENATE("L";D5))>0;20;0))
Thanks,
Wim Goelen