← Prev in month ← Prev in thread

Error types in current version of Excel

From
Patrick Durusau <>
Date
2016-09-19T14:12:46+00:00
ID
Thread
Error types in current version of Excel
Aarti,

Does the current version of Excel have more error values than:

#DIV/0! (2) - Attempt to divide by zero, including division by an empty
cell.
#NAME? (5) - Unrecognized/deleted name.
#N/A (7) - NA. Lookup functions which failed and NA() return this value.
#NULL! (1) - Intersection of ranges produced zero cells.
#NUM! (6) - Failed to meet domain constraints (e.g., input was too large
or too small)
#REF! (4) - Reference to invalid cell.
#VALUE! (3) - Parameter is wrong type."

Hope you are at the start of a great week!

Patrick

-- 
Patrick Durusau

Technical Advisory Board, OASIS (TAB)
OpenDocument Format TC (OASIS), Project Editor ISO/IEC 26300
Co-Editor 13250-5 (Topic Maps)

Another Word For It (blog): http://tm.durusau.net
Homepage: http://www.durusau.net
Twitter: patrickDurusau
← Prev in month ← Prev in thread