Thread: Multi-condition if formula

Hi,

1st post and any help is much appreciated.

I have a multi conditional formula that I can't make work. But when I break out each condition it works separately.

what I am trying to do is allocate costs (calculated daily average) over the appropriate period.

eg. 1/15/10-1/14/11 $365.00 total, =$3.65 per day (over 364 or 365 days)

I need to have a formula that knows that on jan 2010- it gets xx days of cost.

The problem I have is that

1) if I drop my current formula into 12/31/08, a calculation occurs and it should not.
2) also if I drop my current formula into Jan 2011, a future year, it does not work.

Please see attached.