Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 ....] |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel equation explanation | Excel Worksheet Functions | |||
Where to find formula & explanation on Compound Interest etc | Excel Discussion (Misc queries) | |||
explanation on how to use the functions for excel | Excel Discussion (Misc queries) | |||
explanation on how to use the functions for excel | Excel Discussion (Misc queries) | |||
Can I make pop up explanation boxes in Excel | Excel Discussion (Misc queries) |