Error reference

Every error that the Calculator and the Sheet display, its meaning, and its fix.

When a formula does not return a value, the Calculator result line shows an error code and a message, such as E_NO_DATA and the missing input. A Sheet cell shows a short marker instead, such as #N/A. Several codes share the marker #ERROR. Hover over the cell to display the code and the message, then find the code in the table.

The message identifies the argument or the cell that caused the error. A cell with an error keeps its formula. Edit the formula in place and press Enter to run it again. For the arguments of each function, see the function reference.

code	display	meaning	fix
E_ARITY	#ERROR	The function got too many or too few arguments.	Check the function reference for the arguments the function takes, then add or remove one.
E_CYCLE	#CYCLE!	The cell refers back to itself, directly or through other cells.	Find the cell that refers back to itself, directly or through other cells, and point it at another cell.
E_DIM	#ERROR	Two values do not line up: two series cover different dates, or two matrices have sizes that do not fit together.	For two series, wrap each side in align, each naming the other series, so both cover the same dates. For matrices, check the row and column counts.
E_DOMAIN	#ERROR	An argument is outside the range the function takes, such as a window longer than the series.	Check the argument against the range the function reference gives, such as a window no longer than the series.
E_INTERNAL	#ERROR	The calculator hit a fault of its own.	Copy the formula and the message and report them; the formula itself is not at fault.
E_NO_DATA	#N/A	A value is missing: an empty cell, a day with no value, or a symbol the site holds no data for.	Fill the empty cell, or check that the site holds history for that symbol.
E_NO_SOLUTION	#ERROR	The loan payment solver found no answer for the numbers given.	Check the signs: money you receive is positive and money you pay is negative. A loan with a positive amount and a positive payment has no answer.
E_REF	#REF!	A reference names a cell, sheet or workbook that does not exist, such as a deleted sheet or a closed workbook.	Retype the reference, or reopen or rename the workbook it names.
E_SLOT_ARGS	#ERROR	A data function got a cell or a formula where it needs a symbol typed in quotes.	Type the symbol in quotes, such as iv30("SPY"). A data function cannot read its symbol from a cell.
E_SPILL	#SPILL!	A history has no room to fill down the column, because a cell below holds something.	Clear the cells below the formula, then press Enter on the formula again.
E_SYNTAX	#SYNTAX?	The formula cannot be read, such as a missing bracket.	Check for a missing bracket, quote or comma. In the calculator, the number after @ is the position where reading stopped.
E_TYPE	#ERROR	An argument is the wrong kind, such as a number where the function needs a series.	Check the function reference for what each argument takes, such as a series where you gave a number.
E_UNKNOWN_NAME	#NAME?	The name is not a function, a constant or a named cell.	Check the spelling, or pick the name from the list that opens as you type.