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
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 worksand also the solution from "ConnectionLost" (IFERROR) works perfect
Regards Fschou / Frank
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks