How do print following cells according to my number.

[PeterHan123]

Capture3.PNG

I want fill up the cell on Column F based on the values on C4 and C5. So for example, ON time is 1 and OFF time is 4.

So it will print 1(ON) and 0 (OFF) according to the values key in C4 and C5.

Then, it will repeat continuously.
Capture.PNG

I know I can just drag and fill, but will that be possible to make it to formula?

Because, I want to make it automated where users just fill up the values in C4 and C5, then the it automatically fills up column F.

Thank you so much in advance!

[JohnTopley]

Try

in F2

=IF(MOD(ROWS($1:1)-1,$C$4+$C$5)<$C$4,1,0)

[Limor_OP]

try this :
=IF((F2/($C$7+1))-INT((F2/($C$7+1)))=0,1,0)