Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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 |