Almost all functions I try to use in Numbers give me a syntax error with no explanation what is wrong (red triangle with exclamation mark, only says "The formula contains a syntax error." when clicked). I'm on MacOS, NOT in the iPad version and have version 10.3.5 on Big Sur.
UPPER("foo") and it displays
FOO. So this gives me confidence that I know how to invoke functions.
However then I actually wanted to use the find function. I try
FIND("e", "where on earth") which is literally copied and pasted from the function help. All it does is give me an error.
As said, all it gives me for details is this:
For reference the function help says in the example section
=FIND("e", "where on earth") returns 3 (“e” is the third character in the string “where on earth”).
Surely it must be something very basic I'm missing. When I copy and paste the same function in, say, Google Sheets, it's working perfectly.