if than else formula help
 

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.

if than else formula help
 

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$1B1,0,10)

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


--
Greetings from New Zealand

"betsy" wrote in message
...
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.

if than else formula help
 

oops

B1 has 01/01/07
C1 has 01/02/07

Bill

"betsy" wrote in message
...
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.