Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|