Unable to Evaluate Formula
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
|