Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
=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 |
#3
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|