Variable for automatic increase

[thparian]

Hello all,

I want to declare a variable X somehow, which will fill a column in my worksheet with values 0<=X<=60, increasing every time by 2. I mean it will start from A1=0, A2=2, A3=4.........A30=60
It has to be done by a formula and not by hand like cell = previous + 2.

Does anybody have an idea???
Thanks a lot!

[zbor]

You can put +2*ROW(A1) and extend...

[thparian]

Thanks zbor, this seems to work.
But it starts counting from 2 until 0 and will keep increasing unless i stop extending at 60. How can i limit this to 60?

[zbor]

+2*ROW(A1)-2

and for second question you can put: =MIN(60;formula)

This will raise till 60 and 60 after that

[thparian]

Much better now!!!!!
Thanks again

[zbor]

mark thread [solved] if you are satisfied with answer