| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
row number in a formula in Excel?
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? |
|
#2
|
|||
|
|||
|
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? |
|
#3
|
|||
|
|||
|
=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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel formula randomly changes to hard-code number | Excel Discussion (Misc queries) | |||
| Excel formula divide list of #s by N to get a number above 40 | Excel Discussion (Misc queries) | |||
| Looking for function or formula to calculate number that is revers | Excel Worksheet Functions | |||
| How to I use ** without Excel thinking I want to type a formula? | Excel Discussion (Misc queries) | |||
| Suddenly Excel can't calculate formula!!! | Excel Worksheet Functions | |||
Linear Mode
