I'm not usually very good at explaining what I'm trying to achieve, but I'll have a go! If you would like me to post an example, please ask.
I'm looking to use the 'Find' function to see whether or not a set of characters is present in a cell. It should return a number greater than 0 if they are present. However I noticed in the Help article on this function that if the set of characters is not present, the formula will always return the #VALUE! error. Is there any way of getting round this so that it gives me a 'proper' (ie. can be used in other formulas) result if the characters are not present?