Hi, welcome to the board.

Let's make some assumptions.

1) Your starting value of 1,000 is held in cell A2.

2) You want to populate the remainder of row 2, i.e. cells B2, C2, and so on.

3) The cell input to determine "...every x columns..." is held in cell A1.

4) For any entry where you are NOT adding an extra 500, you want to simply repeat whatever the previous value was.

5) The value of 500 is stored in cell C1.

Put this in B2 and copy across row 2 as far as required.

Code:=A2+(MOD(COLUMN()-1,$A1)=0)*$B1

## Like this thread? Share it with others