ExcelBanter - =IF formula #NAME? error

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - =IF formula #NAME? error (https://www.excelbanter.com/excel-worksheet-functions/120927-%3Dif-formula-name-error.html)

Access101

=IF formula #NAME? error

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

Max

=IF formula #NAME? error

Glad it helped !
Thanks for the feedback ..
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Access101" wrote in message
...
That works just great, thank you Max. Happy Holidays!

All times are GMT +1. The time now is 12:30 PM.