Mark

If the start date in D42 is prior to the month (I3) then take the base

This isn't clear; well to me it isn't, what do you have in I3, is it a
number representing a month? a date? something else?. When comparing to I3
are we ignoring the year?
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"Mark D" wrote:

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