Formula that will enter text into a loop of cells

[Hotmail]

I have four cells in a row, A1:A4. I have another cell B1 that's linked to a form scroll bar. So each time I increment the scroll bar cell B1 increments upwards by 1.

So what I'm trying to get in A1:A4 is hard to describe... I want an "X" to move repeatedly through the four cells, A1 to A2, A2 to A3, A3 to A4, and then form A4 back to A1, and repeat... so here's another way to describe it.

If B1 = 1 then put an "X" in A1
If B1 = 2 then put an "X" in A2
If B1 = 3 then put an "X" in A3
If B1 = 4 then put an "X" in A4
If B1 = 5 then put an "X" in A1
If B1 = 6 then put an "X" in A2
If B1 = 7 then put an "X" in A3
etc, etc, etc....

Is there a formula that I can use to make this work? I actually have a series of 63 cells that I'm trying to cycle an "X" through. But I'm hoping if I can understand the formula for four cells, then it will hold true for 63 also.

Appreciate any help or insights into such a formula!

[JBeaucaire]

Try these formulas:

A1: =IF(MOD($B$1,4)=1,"X","")
A2: =IF(MOD($B$1,4)=2,"X","")
A3: =IF(MOD($B$1,4)=3,"X","")
A4: =IF(MOD($B$1,4)=0,"X","")



To do it for 63 cells, I would use this in the first 62:
A1: =IF(MOD($B$1,63)=ROW(),"X","")

And in A63:
=IF(MOD($B$1,63)=0,"X","")

[Hotmail]

Thanks very much JBeaucaire. I will plug these formulas in later tonight and post back how it turns out. Your speedy reply is greatly appreciated!

Yep... it worked. Thanks again!