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
|