if than else formula help

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
Back
Top