IF functions with references to drop downs.

[tomasu]

Hi all,

Can someone help me with this issue?

I have if functions including the drop downs for months when employee starts and finishes.

The problem is employee starts in Jan so you select Jan from drop down and he gets salary in January 2015 and so on, but if you select the finished month from drop down to be (feb) he should be pain in feb but I'll get 0 instead of salary. It needs to show a salary in the finishing month as well, but not any other pst the finishing month.

Can you please help me.

I am attaching the salary budget sheet.

Many many thanks

[shukla.ankur281190]

Sheet is not attached dear