Bi-Weekly budget with excel 2003
=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.
|