The wizard result is not given in the cell:
=FIND({“A”;“B”;“C”},“SAMPLE TEXT”)
Getting #NAME? expecting {2;#VALUE!;#VALUE!}
Then click OK
The wizard result is not given in the cell:
=FIND({“A”;“B”;“C”},“SAMPLE TEXT”)
Getting #NAME? expecting {2;#VALUE!;#VALUE!}
Then click OK
This is not a function issue, this is function wizard issue. Entering the formula in formula bar, and using Shift
+Ctrl
+Enter
to complete it, makes it work as expected. You are welcome to file a bug report.
Could someone confirm that bug?
Fixed for 6.4.5