Difference between revisions of "Documentation/How Tos/Calc: SEARCH function"
From Apache OpenOffice Wiki
< Documentation | How Tos
GreatBigBore (Talk | contribs) m (Typo) |
|||
Line 72: | Line 72: | ||
::: returns <tt>'''"ERR: Missing Substring"'''</tt> (... allowing the IF() to function, and not propagating the error from the SEARCH() function. | ::: returns <tt>'''"ERR: Missing Substring"'''</tt> (... allowing the IF() to function, and not propagating the error from the SEARCH() function. | ||
:: NOTE: In practice, it may be more maintainable to use ISNUMBER() to avoid negative logic, and it is more indicative of the evaluation desired: if the substring has a position, then ISNUMBER() is TRUE, else ISNUMBER() is FALSE. | :: NOTE: In practice, it may be more maintainable to use ISNUMBER() to avoid negative logic, and it is more indicative of the evaluation desired: if the substring has a position, then ISNUMBER() is TRUE, else ISNUMBER() is FALSE. | ||
− | {{ | + | {{SeeAlso|EN| |
* [[Documentation/How_Tos/Calc: REPLACE function|REPLACE]] | * [[Documentation/How_Tos/Calc: REPLACE function|REPLACE]] | ||
* [[Documentation/How_Tos/Calc: FIND function|FIND]] | * [[Documentation/How_Tos/Calc: FIND function|FIND]] |
Revision as of 07:49, 17 July 2018
CALC FUNCTIONS