=IF formula #NAME? error
 

XL is returning the NAME error because it doesn't recognize the function instr

Is that a UDF? If so check to see if the code is properly formatted/debugged.

Dave
--
Brevity is the soul of wit.


"Access101" wrote:


All three of these are wrong, I can't think of a fourth:

=If(instr(A1, "test"), "Y", "N")
=If(instr(A1, "test")=-1, "Y", "N")
=If(instr(A1, "test")=True, "Y", "N")

Cell A1 contains: This is a test