=IF ( FIND ( xxx gives a #VALUE! so the 'Not True' is not executed

Hello Forum,
I am quit experienced in Excel one say, but I probably forgot how to tacle next problem.

=IF(FIND("DATE";A2;1) > 0; MID(A2;1;FIND("DATE";A2;1)-2); A2)

A2 is "Are you available at DATE : xxxx" end gives the right result, but....

if A2 is i.e. "Are you available at xxxx" then the result is #VALUE!

How to check on #VALUE! (TRUE or another check ???) or how to change my FIND clause

Thanks for your help if possible
Regards Frank / Fschou

You would normally use it like this:

=IF(ISNUMBER(FIND(...)), action_if_found, action_if_not_present)

SEARCH might be better than FIND, as it is not case-sensitive.

Hope this helps.

Pete

Thanks Pete, it works and also the solution from "ConnectionLost" (IFERROR) works perfect

Regards Fschou / Frank

Thanks Forum Guru,
Yes its so simple and IT WORKS ...

Pete send me the "IF(ISNUMBER(FIND(...)), solution that works also.

OK Regards Frank / Fschou