RE: Error types in current version of Excel

[Aarti Nankani <anankani@microsoft.com>]

Hello Patrick,

Here’s the response from the product team:

An additional value #REF! - Reference to invalid cell.

Thanks,
Aarti


-----Original Message-----
From: Patrick Durusau [mailto:patrick@durusau.net] 
Sent: Monday, September 19, 2016 7:13 AM
To: Aarti Nankani <Aarti.Nankani@microsoft.com>
Cc: OASIS OpenDocument TC List <office@lists.oasis-open.org>
Subject: 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
patrick@durusau.net
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