Say your variable (50) is in A10, and you want to copy it across to every

nth cell, from B10 to M10.

Your n value is entered in A9.

Try this formula in B10, and copy across to M10:

=(MOD(COLUMNS($A:A),$A$9)=0)*$A$10

--

HTH,

RD

=====================================================

Please keep all correspondence within the Group, so all may benefit!

=====================================================

Thanks Joel,

That is useful but not quite what I want (being lazy I don't want to fill in

100's of cells manually).

I came up with a kludge:

F G H I J

Cost Freq Start End Incr

1,100 A 1 29 5%

Row 2 cell K2 is an integer representing the month (1,2,3, etc.)

Freq can be A (annual) Q (quarterly) or M (monthly, max 36).

The value in J is an allowance for cost increase.

And the formula in K3 and each cell rightwards from there is:

=IF(K$2>$I4,0,IF(AND($G4="a",OR(K$2=$H4,K$2=$H4+12,K$2=$H4+24)),$F4*(1+($J4/12))^K$2,IF(AND($G4="q",OR(K$2=$H4,K$2=$H4+3,K$2=$H4+6,K$2=$H4+9,K$2=$H4+12,K$2=$H4+15,K$2=$H4+18,K$2=$H4+21,K$2=$H4+24,K$2=$H4+27,K$2=$H4+30,K$2=$H4+33,K$2=$H4+36)),$F4*(1+($J4/12))^K$2,IF(AND($G4="m",K$2>=$H4),$F4*(1+($J4/12))^K$2,0))))

Messy, but it works.

If you can reproduce it maybe you can tell me how to simplify it.

Thanks again

Mike