Err:509 -

Two values or cell references are placed next to each other without an operator, such as =A1 B1 .

A slight misspelling or misplaced operator inside complex formulas. Err:509

Sometimes, copying formula text from another application can introduce hidden, illegal characters. Re-typing the formula often resolves this. 4. Correct Function Structure Two values or cell references are placed next

Common Formula ERROR Codes 502, 509, or 522 in LibreOffice Calc Re-typing the formula often resolves this

For a quick visual overview of common LibreOffice formula errors, including 509, you can view this educational video explanation . If you'd like, I can:

When working with complex formulas in LibreOffice Calc, you may encounter the dreaded Err:509 . This error code is frustrating but relatively simple to diagnose. It almost always indicates a within a formula.

Moving a document from Excel to LibreOffice that uses functions unsupported or interpreted differently by Calc, such as some named expressions. How to Fix Error 509