Exel Functions

The UK's most regular instructor-led training courses.
Training information: excel in courses · Excel course london · Microsoft Excel Training London
See also · excel-courses-london · excel courses in london · excel microsoft training

Resolved · Low Priority · Version 2003

Exel Functions

Julian has attended:
Excel VBA course
Excel Advanced course

by - delegate Julian [2 posts] (2008 Apr 23 Wed, 14:50) Reply

What is the main function of an iserror and how would you use ut practically?

Version	Date	Location	Places available	Book	Next place rate:
Excel VBA 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Sep 8 Mon + 9 Tue	Bayswater	2	book now	£495	£495
2003	2008 Sep 18 Thu + 19 Fri	Bloomsbury	3	book now	£475	£495
2003	2008 Sep 25 Thu + 26 Fri	Southwark	5	book now	£450	£485
2003	2008 Oct 6 Mon + 7 Tue	Bayswater	5	book now	£450	£485
2007	2008 Oct 13 Mon + 14 Tue	Bayswater	7	book now	£345	£399
2003	2008 Oct 23 Thu + 24 Fri	Southwark	5	book now	£450	£485
Full Schedule: See all 44 Excel VBA course dates. Bookings currently available until 26th November 2009.

RE: Exel Functions

by - trainer Pete platinum contributer [799 posts] (2008 Apr 24 Thu, 10:06) Edited on 2008 Apr 24 Thu, 10:08 Reply

Hi Julian, Thank you for your post, in answer to your question the ISERROR function looks at a formula in a particuar cell and considers its accuracy, if the formula is incorrect it will return TRUE and if it is OK it will return FALSE,
The ISERROR function allows you to test whether a cell has generated an error message. This is particularly useful for division by zero (#DIV/0!) errors and is often combined with an IF statement to provide an alternate action if an error is generated.
As an example consider this: =A8-B8/C8 this will return a #DIV/0 error when it is copied and hits a blank cell, so if we dont want to see the #DIV/0
Try this: =IF(ISERROR(A8-B8/C8),"",(A8-B8/C8)) the #DIV/0 will not display, because the IF statement has entered nothing "" when it sees the TRUE statement.
I hope that has shed a little light, if so please click the Resolved link, best regards Pete.

· Microsoft Office and the Small Business: Part 1 Excel
· How to Create Better Excel Spreadsheets: Part Two
· Reasons Why VBA for Excel Training Fails
· Excel Macros for the Non-Programmer
· How Excel Training Can Improve Your Company's Sales Process

Please browse our web site to find out more about
excel in courses and other Microsoft training courses.

Excel tip:

Go to source of a cell

The default setting in Excel is when you double click in a cell it actives the formula in the cell. If you have created a link and want to directly go to that link (say if on another sheet, click on Tools -options and take off the tick for eidt it directly in cell

View all Excel hints and tips