=IF formula #NAME? error
 

Ignore my first response. instr can only be used in VBA:
http://techonthenet.com/excel/formulas/instr.php

What are you trying to do? There's probably a different function.
--
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