See the answers to NordicElf's almost identical question "row number in
a formula in Excel?"

In article ,
"Okashii" wrote:

Does anyone know how I can use the row number as a value in the calculation
of a cell value?
e.g. for row 10 I want a cell = 3*4/10.