Your welcome
If this was helpful please say yes at the bottom of the screen. thank you

"ardy" wrote:

On Feb 24, 11:58 am, Eduardo
wrote:
Hi Ardy,
Try

=IF(ISNUMBER(FIND("ND",AH2))=TRUE,"N",IF(AH2AQ2," Y","N"))

It works for me



"Ardy" wrote:
Hello All:
I have this formula =IF(AH2AQ2,"Y",IF(AH2<AQ2,"N",IF
(AH2="ND","N","N")))
it works pritty good with the exception of the ND part. when I test
it I expect to get a N when entering ND in AH2 but get Y. Can any
body show me where I went wrong.

Ardy- Hide quoted text -

- Show quoted text -

Thanks Eduardo:
Works like Charm, I guess the part I was missing was ISNUMBER(FIND
("ND",AH2))=TRUE,"N", which looks into the value and if ND is True
Places a N and the rest is history.......

I do Apriciate from all helping me on this....

Ardy