Forum home » Delegate support and help forum » Microsoft Excel Training and help » microsoft excel courses in - Iserror statement
|
|
|
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. |
microsoft excel courses in - Iserror statement
Resolved · Low Priority · Version Standard
Reply Thu 26 Apr 2007, 09:46Delegate Femi said...
Femi has attended:
Excel Intermediate course
Excel Advanced course
Excel VBA Intro Intermediate course
Iserror statement
How does one use iserror with if statements?
For upcoming training course dates see: Pricing & availability
RE: iserror statement
Hi Femi,
Thank you for the question,
To stop a formula returning a "#DIV/0" Error
If a formula returns a #DIV/0 error message there is a way to avoid such results.
For example the formula =A1/B1 will return a #DIV/0 if B1 is empty or a zero.
If you protect your formulas with the ISERROR function, the formula will then look like this:
=IF(ISERROR(A1/B1),0,A1/B1)
In plain English: should the result of A1 divided by B1 be an error change the result to 0 else show the result of A1/B1.
Hope this helps
Tracy
|