| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to use the rownumber of the current cell in a formula
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| CURRENT TIME IN DESTINATION CELL IF SOURCE CELL IS TEXT | Excel Discussion (Misc queries) | |||
| formula to change current cell value | Excel Worksheet Functions | |||
| formula won't paste from one cell to another with current cell inf | Excel Worksheet Functions | |||
| formula, move to previous cell when the current cell=0 or empty | Excel Discussion (Misc queries) | |||
| Can I get current #row or #column in cell formula? | Excel Discussion (Misc queries) | |||
Threaded Mode
