#NAME?
The formula contains text the engine does not recognise.
What it means
Something in the formula is being read as a name (a function, a named range, or a defined constant) and no such name exists.
How to fix it
- Check the spelling against the function reference.
- Quote text literals: ="total" not =total.
- Define the named range, or replace it with a direct reference.
Common causes
- A misspelled function name, e.g. =SUMM(A1:A2).
- A function this engine does not implement.
- A named range that was never defined or has been deleted.
- Text used without quotes, so it reads as a name rather than a string.
A formula that produces it
=NOTAFUNCTION(1)