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?
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?
One way:
=3/ROW()
In article <[email protected]>,
NordicElf <[email protected]> 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?
=3/ROW()
First row is row 1. Of course you can use =3/(ROW()-1)
--
Kind Regards,
Niek Otten
Microsoft MVP - Excel
"NordicElf" <[email protected]> wrote in message
news:[email protected]...
> 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?
this was meant for a different thread
Last edited by Videogamer555; 02-01-2012 at 01:36 AM. Reason: message in wrong thread, please delete post
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks