Morning all

Having some trouble in getting a formula together. Am hoping someone can
help me

I have to put a formula (believe it to be an if) which has 3 possible outcomes

For example
D42 has a start date - E42 an end date (although not all the time), F42 a
salary figure and finally I3-AR3 has months starting from 31/01/10 - 31/12/12

I need the statment to have the following

If the start date in D42 is prior to the month (I3) then take the base
salary in F42 and divide by 12.

However

If E42's endate is prior to (I3) then don't take F42 and divide by 12 (and
leave the cell blank)

finally

IF D42 has nothing in it then leave the cell blank

Can anybody help me, driving me nuts

Thank you