Sequential numbering based on another number value in a different cell

[lgkartik]

Given a number in Cell A1 say 4

I am looking for a formula to sequentially create numbers from 1 to 9 and subsequent values should be 0's in column B

Values is Column B should be

1
2
3
4
0
0


I am using below two formulas (first in B1 and then I copy the second in subsequent cells)
IF((0+1)>$A$1,0,1)
IF((B1+1)>$A$1,0,B1+1)

However the result is
1
2
3
4
0
1
2
3
4
0
1
2
so on

 

[Kenneth Hobson]

Close, your 2nd needed an OR.
=IF(1>$A$1,0,1)
=IF(OR(B1+1>$A$1,B1=0),0,B1+1)

 

[lgkartik]

Thanks very much