#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.
a formula that produces it
=NOTAFUNCTION(1)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
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