View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
 
Posts: 8,651
Default 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.