Example;

I can place the same value in lets say a1 and b1 and have it fill in that
row with that value as far as I want.

I want this budget to look like this :

4/1/2009 4/15/2009 4/29/2009
Rent $300.00 $0.00 $300.00

However I do not want to type this in for 26 pay periods, how do I do this?
If it was the same number, no problem. Any advice would be helpful.

=300*(MOD(COLUMN(),2))
--
David Biddulph

"BillyBob" wrote in message
...
Example;

I can place the same value in lets say a1 and b1 and have it fill in that
row with that value as far as I want.

I want this budget to look like this :

4/1/2009 4/15/2009 4/29/2009
Rent $300.00 $0.00 $300.00

However I do not want to type this in for 26 pay periods, how do I do
this?
If it was the same number, no problem. Any advice would be helpful.