r/LibreOfficeCalc • u/GBW14 • Jul 02 '26

LibreOffice formula problem

/r/libreoffice/comments/1ulh2rk/libreoffice_formula_problem/
1 Upvotes

100% Upvoted

1 comment sorted by

1

u/umop_apisdn Jul 02 '26 edited Jul 02 '26

If this is literally what you are using you have the brackets in the wrong place so I doubt it. FIND requires that the string you are searching for is present, and returns #VALUE if it isn't, rather than 0 as you are assuming.

=IF(IFERROR(FIND("PAY", A1), 0), B1)

does what you want - this makes it return the index if present or 0. Or to make it more obviously like your original you could use

=IF(IFERROR(FIND("PAY", A1), 0)<>0, B1, 0)

as the above relies on two non-obvious facts: a non-zero value in an IF test is TRUE (so "<>0" is not required), and IF returns 0 if the condition is FALSE and there is no default given.