if than else formula help

B

betsy

I am trying to write a formula to help me build a salary phasing schedule. I
want to be able to change a persons start date and reclaculate the full year
expense. For instance, a person make 120K per year at 10K per month and I
have jan - dec in columuns. If they start jan 1 the exp for jan is 10K, feb
10K mar 10K etc. etc. I want to be able to change hte start date to feb 1
and see jan at 0, feb at 10K, mar 10K etc. etc.

Can you help?

Thanks.
 
B

Bill Kuunders

one way

cell A1 has the start date.
B1 has the month
This cell has 01/02/07 formatted as custom mmm
enter 01/03/07 in C1
highlight B1 and C1 and extend the range across till you get dec


Enter in B2
=IF($A$1>B1,0,10)

extend the formula in B2 across to get the rest of the months
 
Top