Skip to content

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").

  1. The cell shows #NAME?, because no such function exists
  2. 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

Facts last checked on 9 November 2026.

Education, not advice: the Stockertim Dictionary explains what terms mean. It never recommends buying or selling anything.

English