Stockertim Dictionary · Artificial intelligence · Technology
Invented function
Also called invented functions, hallucinated function, made-up function, nonexistent function
In short
A function name that an AI assistant writes into a formula although the spreadsheet program has no such function, which usually shows up as a #NAME? error.
- Beginner
- Concept
- Checked
In detail
Language models generate text that resembles what they have seen, and formulas are text. When asked for a spreadsheet formula, a model may produce a function name that sounds plausible, such as SUMIFRANGE or COUNTUNIQUEIF, but does not exist. It is a form of AI hallucination applied to code. Excel and similar programs respond with #NAME?, the error shown when a name in a formula is not recognised.
Close relatives cause subtler trouble. A function may exist in one spreadsheet program but not another, or only in newer versions, so a formula that works for the person who asked fails for a colleague with an older version. Arguments may be in the wrong order, or an optional argument may be given a meaning it does not have. Function names are also translated in some language versions of spreadsheet programs, and several locales use semicolons rather than commas between arguments, so a formula copied across settings can fail.
The #NAME? error is the easy case, because it is visible. A wrong argument order in a real function usually returns a number, which is far harder to notice. That is why AI-drafted formulas are checked against the program's own function reference or its list of available functions and tested on known cases before use.
Prompts can reduce the risk: stating the program and version, asking for standard functions only, and asking for a one-line explanation of each part. None of these removes the need to test the result.
Worked example
A bookkeeper in Dundee asks an assistant to count distinct customers per region and receives =COUNTUNIQUEIF(A2:A500,B2:B500,"North").
- The cell shows
#NAME?, because no such function exists - Asked for standard functions only, the assistant suggests a combination of COUNTA, UNIQUE and FILTER, which the bookkeeper checks in the function reference and tests on a sample of 10 rows
The invented function was caught at once; the replacement was verified before use.
In practice
People who draft formulas with AI help treat #NAME? as a sign of an invented or unavailable function, check every unfamiliar function name in the official reference, and test formulas on a small sheet of known answers.
Watch out
- A real function with arguments in the wrong order gives a wrong number, not an error.
- A function available in one version or program may be missing in a colleague's.
Learn it properly
Official sources
- AI Playbook for the UK Government · UK Government
- AI and cyber security: what you need to know · National Cyber Security Centre
Facts last checked on 9 November 2026.
Education, not advice: the Stockertim Dictionary explains what terms mean. It never recommends buying or selling anything.