View Single Post
  #6   Report Post  
swatsp0p
 
Posts: n/a
Default


To understand the problem, we need to know what FIND does. It returns
the location number of the first character in the FIND. If it does not
find the value, it returns an error, hence the need to verify that it
returns a number (with ISNUMBER).

Therefore, the formula says that if we have FIND return a number
(meaning it found the value) then tell me you found it, if not, tell me
you didn't find it.

Clearer, now?

Bruce


--
swatsp0p


------------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101
View this thread: http://www.excelforum.com/showthread...hreadid=393921