=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" wrote in message
...
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
|