Just Cannot Get This Formula To Work! (Find)

Hello everyone,

I have this formula here

Please Login or Register  to view this content.

And it works great!, however, I would like to add another find to the code.

I would like "True" to display if excel finds AB in cell A1, OR DB in cell A1 and if nothing is found then nothing to be displayed.

I have tried many variations of this function to no avail.

How would this be accomplished? Can anyone help?

Thank you so much for your time.

Does this work:


=IF(ISERROR(FIND("AB",A1,1)),IF(ISERROR(FIND("DB",A1,1)),"","True"),"True")

Note: the find formula IS case sensitive

Like a charm.

Thanks a lot

I have variated the code to include one more little argument, and it works.

Please Login or Register  to view this content.

However, I would like to include this into the formula:

Please Login or Register  to view this content.

I cannot seem to get it to work. I always get an error... Any thoughts?

Any and all help is greatly appreciated. Thank you very much.