Adding a column and increment each row

jearls11

Hello,

I'm trying to add a new column and increment each row by 0.1.

i have thousands of rows.

 

I am using the sequence function my question is.

in my example:

I start from 0 to 10- incrementing by 0.1 and repeat 1

I want to Start from 0  to the last row. would put in a huge number?

 

 

 

txnelson

You can put in a very large number

or you can get the same results without the need to use a very large number by using this formula

and as can be seen, both approaches result in the same values