=3/ROW()
First row is row 1. Of course you can use =3/(ROW()-1)
--
Kind Regards,
Niek Otten
Microsoft MVP - Excel
"NordicElf" wrote in message
...
How do I use a row number in a formula calculation in excel?
For .e.g I want to have cell = 3/(current row number).
Also is it possible to make row numbers start from 0?
|