Bill:
Thanks. It works. I managed to solve the problem with a variation
=IF(HireDate=0,0,IF(SepDate<Jan,0,IF(Jan<HireDate, "",IF(IncDate=0,OldWage,IF(
JanIncDate,NewWage/12,OldWage/12))))).
But your formula is cleaner. I am dividing new and old salary by 12 to
display montlhy amounts.
The one caveat is that the separation date can not be an empy field. It has
to have some kind of data. Is there a way of displaying the results for null
data for separation. Because as is is now I have to "terminate" an employee
to get his/hers salary. If the formula could capture this data (salary) for
an active employee(no separation date) it would be great. Right now for
active employee I must project a termination date far into the future.
But thanks for your help and reply.
Jurek

"Jurek" wrote:

Need help with building nested if formula.
Have following columns: date of hire, date of separation, date of salary
increase, old pay, new pay, amount of increase, and months of the year.
Trying to build statement that would display monthly salary for months worked
(show blanks outside this range. For example if employee worked from march to
august, display salary for the same months. Outside this range show zero.
Also if in may emplyee got increase in july show old salary for march thru
june and for july thru august a new wage. Is this doable. Please help.
Jurek