If formula and #N/A as a condition

The following formula is fine until I add the the third IF referencing cell
AE2. Cell AE2 has a formula and when it equals #N/A I want my formula to
return "delinquency"

=IF(X2>=DATEVALUE("27/08/2005"),IF(X2<=DATEVALUE("26/09/2006"),IF(ISNUMBER(AE2),"xx","delinquency")))

Thank you for your help,

Esther

=IF(X2>=DATEVALUE("27/08/2005"),IF(X2<=DATEVALUE("26/09/2006"),IF(OR(ISNA(AE
2),NOT(ISNUMBER(AE2))),"delinquency","xx")))

--

HTH

RP
(remove nothere from the email address if mailing direct)


"EstherJ" <[email protected]> wrote in message
news:[email protected]...
> The following formula is fine until I add the the third IF referencing
cell
> AE2. Cell AE2 has a formula and when it equals #N/A I want my formula to
> return "delinquency"
>
>
=IF(X2>=DATEVALUE("27/08/2005"),IF(X2<=DATEVALUE("26/09/2006"),IF(ISNUMBER(A
E2),"xx","delinquency")))
>
> Thank you for your help,
>
> Esther

It looks like you could use:

=IF(AND(X2>=DATE(2005,8,27),X2<=DATE(2006,9,26),
ISNUMBER(AE2)),"xx","delinquency")
(one cell)

I changed the datevalue() to date() to avoid any local settings.



EstherJ wrote:
>
> The following formula is fine until I add the the third IF referencing cell
> AE2. Cell AE2 has a formula and when it equals #N/A I want my formula to
> return "delinquency"
>
> =IF(X2>=DATEVALUE("27/08/2005"),IF(X2<=DATEVALUE("26/09/2006"),IF(ISNUMBER(AE2),"xx","delinquency")))
>
> Thank you for your help,
>
> Esther

--

Dave Peterson