An error returned from a formula calculation.

Standard Error Codes 0. #PARSE! If the formula contains a syntax error. (Not part of the OOXML spec.)

1. #NULL! Intersection of two ranges that don't intersect.
2. #DIV/0! Division by zero.
3. #VALUE! Wrong type of argument or operand.
4. #REF! Invalid cell reference.
5. #NAME? Unrecognized name (function, named range, etc.).
6. #NUM! Invalid numeric value.
7. #N/A Value not available.

Office 365

8. #GETTING_DATA This raised when for long running calculations that not yet completed.

(Saves as #N/A to disk) 9. #SPILL! Formula's output range is blocked.

SpillErrorScalarSubType | "Unknown" | "Collision" | "IndeterminateSize" | "WorksheetEdge" | "OutOfMemoryWhileCalc" | "Table" | "MergedCell"

Office 2023

10. #CONNECT! This occurs when a data type is used that is not currently supported in this version of Excel.
11. #BLOCKED! Indicates that an action or feature is blocked, possibly due to security settings, protected view, or other restrictions. Often related to online features, external links, or macros.
12. #UNKNOWN! May be returned in the case of a protected workbook.
13. #FIELD! Invalid field name for a data type.
14. #CALC! Calculation error (often with LET or LAMBDA or a splitted array).
16. #BUSY! When waiting on an external data source to return data.
19. #PYTHON! The Python interpreter returned the following error: Unexpected failure.
20. #TIMEOUT! Indicates that the operation took too long to complete.