Excel formula checker
Paste a formula that doesn't work. The checker finds typos, missing brackets and quotes, and risky lookups. Add a few rows of your data and it points at the exact part an error starts in, and says why. It runs in your browser: nothing is sent anywhere.
What it checks
- Spelling. A function name Excel doesn't know, with the closest real one: VLOKUP for VLOOKUP.
- Brackets and quotes. Brackets that are never closed, text without quotes, and the curly quotes that web pages and documents put in place of straight ones.
- Arguments. Too few or too many for the function, and ranges of different sizes where they must match.
- Silent mistakes. VLOOKUP and MATCH without their last argument, which match approximately, and comparisons written as 1<A1<10.
- Language. A formula written for another language of Excel, with its English translation.
- Errors in the result. With your data in the sheet, where a #N/A, #VALUE!, #DIV/0! or #REF! starts, and the reason: an empty cell, a space at the end of a code, a number stored as text.
Examples of what it says
=VLOKUP(A2, B:C, 2, FALSE): There is no function called VLOKUP. Did you mean VLOOKUP?=IF(A1=Yes, 1, 0): Yes is not in quotes. Excel reads it as the name of a cell range and shows #NAME?.=VLOOKUP("P-1", A2:B3, 2, FALSE): "P-1" is in the list, but A2 holds "P-1 ", with a space at the end, so the two don't match.=A2/B2: The formula divides by B2, which is empty.
It reads formulas as English Excel writes them, on a single sheet, and knows the 376 functions in the reference.
What each error means
- #N/A: A lookup could not find the value it was given.
- #VALUE!: The formula was given the wrong kind of value, such as text where it needs a number.
- #REF!: The formula refers to a cell that no longer exists.
- #DIV/0!: The formula divides by zero or by an empty cell.
- #NAME?: Excel does not recognise a word in the formula.
- #NUM!: The calculation has no valid number as its answer.
- #SPILL!: A formula that returns several values has no room to put them.
- #CALC!: A formula that returns a list ended up with nothing to return.
- #NULL!: Two ranges that were expected to cross do not.
- #####: The column is too narrow to show the number, or a date is negative.
- Circular reference: A formula depends on its own result.