No, my help page looks the same as yours. I don't think I've seen a single
page in Excel help that has the information the way you list it rom your
book, though the information for each error type is given separately in
Help.
The info from your book, presumably, is on-line at
http://www.dummies.com/WileyCDA/Dumm...e/id-3507.html
--
David Biddulph
wrote in message
...
On Nov 28, 8:44 pm, "David Biddulph" <groups [at] biddulph.org.uk
wrote:
With Excel 2003, when I follow the advice to enter #NULL! into help, one
of
the first topics listed is "ERROR.TYPE worksheet function". (Similarly
if
you use #VALUE! in help.) Is that what you are looking for?
My version of the ERROR.TYPE() help page has a list of those error
values, not an explanation of them. I have attached the help page
below. Does yours look significantly differently?
Of course, I could enter each error value into the Help search field
and go to each "Correct a #... error" link, which describes the
conditions that cause that error.
But I thought I had found a single Help page that had a synopsis of
each error value -- that is, a short explanation. Something like this
(from my book):
#DIV/0! Formula is trying to divide by zero
#N/A Formula uses or refers to a cell that uses the NA()
function.
(Also some other conditions, such as a LOOKUP error.)
#NAME? Formula uses a name that Excel does not recognize.
#NULL! Formula uses an intersection of two ranges that do not
intersect.
#NUM! Function argument is outside its valid range of values.
#REF! Formula refers to a cell that is not valid.
#VALUE! Formula includes an argument or operand of the wrong type.
However, on second thought, since some knowledgable Excel users are
unable to find it themselves, I am beginning to think that perhaps I
only found that information (in one place) in my book.
-----
ERROR.TYPE
See Also
Returns a number corresponding to one of the error values in Microsoft
Excel or returns the #N/A error if no error exists. You can use
ERROR.TYPE in an IF function to test for an error value and return a
text string, such as a message, instead of the error value.
Syntax
ERROR.TYPE(error_val)
Error_val is the error value whose identifying number you want to
find. Although error_val can be the actual error value, it will
usually be a reference to a cell containing a formula that you want to
test.
If error_val is ERROR.TYPE returns
#NULL! 1
#DIV/0! 2
#VALUE! 3
#REF! 4
#NAME? 5
#NUM! 6
#N/A 7
Anything else #N/A
Example
The example may be easier to understand if you copy it to a blank
worksheet.
[.... elided ....]