SPREADSHEET HELP, WITHOUT THE HEADACHE

A little less guessing.
A lot more clarity.

A formula stops working and suddenly your whole sheet is on hold. Start with a quick structure check, or follow a plain-English example that shows what to look at next.

Check my formula Browse the guides

No workbook upload needed for the core browser-based tools. They check structure, not your spreadsheet's private data.

AN EVERYDAY FORMULA
ABC
1QuantityPriceDiscount238010%
TRY THIS FORMULA=ROUND(A2*B2*(1-C2),2)
Expected result216.00

It's easier to spot a mistake when you know what the answer should be.

START WITH THE PROBLEM

What are you trying to sort out?

Pick the job in front of you. Each tool has one purpose and explains its limits.

01 / DIAGNOSE

Why isn't my formula working?

Check brackets, quotes, function tokens and separators before changing the calculation.

Formula checker 02 / REPAIR

Something broke when I pasted it.

Tidy up smart quotes, missing equals signs and other copy-and-paste problems.

Formula fixer 03 / UNDERSTAND

This formula is too long to read.

Lay out nested expressions so you can follow one argument at a time.

Formula formatter 04 / TRANSLATE

It works on a colleague's computer.

Compare supported function names and separators across spreadsheet languages.

Formula translator

FROM THE GUIDEBOOK

Don't hide an error until you know what caused it.

A clean-looking report isn't always a correct one. If every broken lookup becomes a blank cell, the problem doesn't disappear; it just gets harder to find.

Our guides show the input cells, the formula and what you should expect to see, including awkward edge cases.

Read the IFERROR guide
IN PRACTICE

Missing is not the same as zero.

When a product isn't in your price list, returning 0 can make it look free. A visible “Missing ID” label keeps the exception in view until somebody checks it.

See the XLOOKUP example

LOOK IT UP

References worth keeping nearby.

Open the function library →
XLOOKUPFind a match without hiding what's missing.SUMIFSBuild totals around dates and conditions.IFMake the decision rule readable.Error guideStart with the message you're seeing.

READ AT YOUR OWN PACE

Recent notes from the guidebook.

All guides →

ONE IMPORTANT LIMIT

A syntax check isn't a workbook test.

CellLingo can spot mechanical warning signs, explain functions and help you compare small examples. It cannot see your named ranges, linked files, hidden rows or business rules. Always check an important calculation in the spreadsheet itself. How we write and review our guides →