OASIS Mailing List ArchivesView the OASIS mailing list archive below
or browse/search using MarkMail.


Help: OASIS Mailing Lists Help | MarkMail Help

office message

[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]

Subject: RE: Error types in current version of Excel

Hello Patrick,

Here’s the response from the product team:

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


-----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


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 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

[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]