I"m looking for a function/command set list.
Thought it would be easy to find but it’s not.
Right now I want to know about SEARCH() because it’s returning #NA when it can’t find. Well, maybe it is. It is nested in a MATCH() which is nested in a INDEX().
So I need to look them all up and figure out what’s doing. Thought there’d be a list in the help on the spreadsheet but there isn’t.
Searching Calc help using either Index (to the left) or Contents (to the right) seems to work for me:
Also the Function Wizard seems to point to the correct help entry when you press F1 inside the function:
And indeed, the Functions list in the Function Wizard works here.
2 Likes
Additionally there’s a wiki page listing functions, leading to even more details and examples: https://wiki.documentfoundation.org/Documentation/Calc_Functions/List_of_Functions .
2 Likes