Home / Discussions

Reply to Message

Solution
Use ISERROR in the formula to solve the #VALUE! problem.

Example:
=IF(ISERROR(FIND("-",A1)),"NotFound","Found")
Posted by greg.steward@...
17th Jan 2008