Hi:

I am trying to evaluate the following formula

=IF(OR(LEDx<=ASDx,LSDx(EDATE(ASDx,12))),0,IF(AND( LSDx<=ASDx,LEDx
(EDATE(ASDx,11))),12))

where

LSDx = 9/1/06
ASDx= 9/1/06
LEDx= 8/31/08

but it returns a #Name?. However if I execute the formula it returns
the value I expect which is 12.

If I split the formula into the 2 IF statements (after adding in a
close paren) I can evaluate either IF statement

Since I am using EDATE, I have the Analysis ToolPak addin installed. I
have also tried loading and unloading it to make sure.

What am I doing wrong?

Thx

Mike