Hello - I'm confused as to which function, or combination of functions, I should be using to get the figures I want... I am using excel 2007.

I am working on employee payroll budget for the next 60 months (5 years) and need to factor in a salary increase if the employee has been with the company for at least 9 months in that particular calendar year.

I have a fixed salary increase for each year of employment (year1=3%, year2=5% ect).

Employees who work for a minimum of 9 months are entitled to the increase.

Increases will be effective in the Jan payroll each year (Month 13,25,37,49).

So I need a formula, starting in month 13, that says the following in Month 13 :
If Start month is less than 4 use $4000 plus 5%
If start month is equal to 13 and greater than 4, use $4000
If start month is greater than 13 use 0

I Can do all of the above separately but run into problems when combining... I tried the if/and function but it is limited to only a true and false output and I need 3 different outputs...

Any help is greatly appreciated!