Bill:
I have one more question. What is gt and lt in you formula?
Jurek

"Bill Pfister" wrote:

Jurek, this is easier to show in a workbook, but here's an explanation. Let
me know if you'd like the example.

C5: hire date
D5: separation date
E5: salary increase date
F5: old pay amount
G5: new pay amount
H5: amount of increase amount (not needed here)

J3-U3: date headers (1/1/06, 2/1/06, ... , 12/1/06)

J5-U5: put this formula in J5 and copy through U5:

=IF( AND( J$3$C5, J$3<$D5 ), IF( J$3=$E5, $G5, $F5 ), 0 )



"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