Spreadsheet- Error messages related to the formulas

December 2016



The error messages displayed in spreadsheet cells will vary depending on the software you are using. For example, OpenOffice Calc also displays errors in the form of numeric code in the status bar.

Error: #####


The numeric value entered in a cell is too large to be displayed in the cell. You can increase the column width by dragging the edge between the headers of columns.
When you subtract dates and time interval, check the validity of the formula. Dates and time interval must have positive values. If a date or time formula produces a negative result, the spreadsheet displays #### in the target cell.

Error: #VALUE


The #VALUE value is displayed when:
  • Using an inappropriate type of argument or operand.

Error: #DIV/0


This error occurs when a formula divides by zero. This is often due to a cell reference to an empty cell or a cell containing 0 as a divisor or entering a formula containing an explicit division by 0, eg = 5/0.

Error: #DIV/0


This error occurs when a formula divides by zero. This is often due to reference to an empty cell or a cell containing 0.

Error: #NAME


The #NAME error is displayed when the spreadsheet does not recognize text in a formula. This may be due to the removal of a name used in the formula or the use of a name that does not exist.
Another common cause, entering text in a formula without framing by double quotes (it is interpreted as a name) or omission of the colon (:) in the reference range.

Error #N/A or 502 (Calc)


The #N/A error appears when a value is not available to a function or formula.

Error: #REF


The #REF error appears when a reference cell is not valid. This may be due to their removal or displacement.

Error: #NUM! or 513 (Calc)


This error occurs when a function argument is inappropriate or formula produces a number too large/small to be represented.

Error: #NULL or 509 (Calc)


This error occurs when you specify an intersection of two areas that in reality do not intersect. This happens when an incorrect a range operator or a cell reference is used.
Original document published on CommentcaMarche.net.

Related :

This document entitled « Spreadsheet- Error messages related to the formulas » from CCM (ccm.net) is made available under the Creative Commons license. You can copy, modify copies of this page, under the conditions stipulated by the license, as this note appears clearly.