Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel consultancy - ISERROR
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
excel consultancy - ISERROR
Resolved · Low Priority · Version Standard
Reply Mon 11 Dec 2006, 16:57Delegate Imran said...
Imran has attended:
Excel Intermediate course
Excel Advanced course
ISERROR
When should this function be used? For what purpose? Should it be used in combination with another function?
Thanks
For upcoming training course dates see: Pricing & availability
RE: ISERROR
ISERROR is one of a group of error checking functions.
It is used to check whether a specific cell contains an error.
Value refers to any error value (#N/A, #VALUE!, #REF!, #DIV/0!, #NUM!, #NAME?, or #NULL!).
Returns a TRUE / FALSE.
Can be combined with other functions, depending on your requirements. This is called nesting functions, like the multiple IF statement you covered on the advanced course.
|