Fast syntax sanity check
Excel Formula Checker
Inspect a formula for common structural warning signs before you start changing workbook logic. The checker runs locally in your browser and does not calculate workbook values.
Try:
No checks run yet.
What the checker looks for
Formula shell
Checks for the leading equals sign and balanced parentheses.
Function tokens
Compares detected function calls with CellLingo’s mapped and reference function data.
Separators
Flags mixed comma/semicolon patterns outside quoted text so you can review locale differences.
Broken references
Calls out literal #REF! markers that already indicate a damaged reference.
A practical debugging order
- Fix mechanical syntax first. Confirm
=, parentheses, quotes and separators. - Check names next. A token can be a misspelled function, a localized function name, a named range or an add-in function.
- Then inspect references. Verify sheet names, table columns, named ranges and absolute/relative references.
- Finally test business logic. Check criteria, data types, blanks, zeros and edge cases in the actual workbook.
What this tool cannot verify: whether a range contains the right data, whether a named range exists, whether a table column is correct, or whether the formula returns the business result you intended. Use the workbook itself for those checks.