I am really stuck on the function statement in column four. I realize it is
not correct as it is written but I simply cannot figure out a way to write it
correctly. Can anyone help?

To explain the table below it is a time line of repairs and stocking levels
needed to have on hand during repairs.

The first column lists days 1 - 720 [labeled Day]

The second column [labeled Failure] has a formula of
"=IF(A8/$B$1=ROUND(A8/$B$1,0),1,0)" which works fine to calculate how many
days between an expected repair

The third column [labeled RI] with a formula of
"=IF($A8/($B$1+$B$4)=ROUND($A8/($B$1+$B$4),0),1,0)" also works fine, same
formula as the second column with some added days

The fourth column [labeled RC] is where I am stuck. the formula currently in
the cell not working correctly is
"=IF($A8<$B$2+$B$7,0,IF($A8=$B$2+$B$7,1,IF($A8/$B$2=ROUND($A8/$B$2,0),1,0)))"
It is the last portion of the formula not working correctly. In this case I
need to have a starting point..such as day 11....and then input a "1" in a
cell for every "7" days after day 11.

The fifth column [labeled OH] has the formula "=$B$6-C8+D8" simple works
fine just gives me the expected on hand quantities of inventory during a
repair cycle.

(Cell B1) Failure                  5           
(Cell B2) Repair Time                7           
(Cell B3) Total Time                  9           
(Cell B4) Ship Time1                  2           
(Cell B5) Ship Time2                  1           
(Cell B6) Start In-stock Qty         4           
(Cell B7) Start Repair                  4

           
Day    Failure    RI    RC    OH
1    0    0    0    4
2    0    0    0    4
3    0    0    0    4
4    0    0    0    4
5    1    0    0    4
6    0    0    0    4
7    0    1    0    3
8    0    0    0    3
9    0    0    0    3
10    1    0    0    3
11    0    0    1    4
12    0    0    0    4
13    0    0    0    4
14    0    1    1    4
15    1    0    0    4
16    0    0    0    4