Excel errors


Excel cell errors 1 to 7


Examples shown in figure 1, listed in order of Excel's ERROR.TYPE function return value:

  1. #NULL!
  2. #DIV/0!
  3. #VALUE!
  4. #REF!
  5. #NAME?
  6. #NUM!
  7. #N/A

New in Office 365:

  1. #SPILL!
  2. #UNKNOWN!
  3. #FIELD!
  4. #CALC

Fig 1: Excel Web App #1: Excel error examples (1 to 7) - with formulas shown by the FORMULATEXT function

Excel cell errors #8


  1. #GETTING_DATA. This is a transitory error, returned as code 8 by the ERROR.TYPE function. The error is raised when the workbook contains a large and complicated formula structure and the calculation has not yet completed. It only appears during the calculation phase

Excel ERROR.TYPE function


error-type-numbers-ver2
Fig 2: ERROR.TYPE syntax - returns a number corresponding to one of the error values in Excel. For example, a #NULL! returns 1 (see row 7 in figure 1). Office 365 version - right panel

Excel cell errors #9, #12, #13, #14


  1. #GETTING_DATA. This is a transitory error, returned as code 8 by the ERROR.TYPE function. The error is raised when the workbook contains a large and complicated formula structure and the calculation has not yet completed. It only appears during the calculation phase
  1. #SPILL. The spill range for a spilled array formula is not blank
  1. #UNKNOWN. This occurs when a data type is used that is not currently supported in this version of Excel.
  1. #FIELD. This occurs when a referenced field is not found in linked data type
  1. #CALC. This occurs when Excel's calculation engine encounters an unspecified calculation error with an array (dynamic and/or spilled)