View Single Post
  #2   Report Post  
JE McGimpsey
 
Posts: n/a
Default

One way:

=3/ROW()

In article ,
NordicElf wrote:

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?