Bookmark page
Printable version
Course updates
|
RSS feeds
Hints and tips home » Excel hints and tips » Stop Formula Returning A "#DIV/0" Error
Stop 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.
Added by Carlos on 24th November 2006
More Excel hints and tips, like:
 |
What Endorsements Should Your Training Provider Have? If a training provider is established and also of good quality, then they should be endorsed, either by happy customers or other recognised areas of industry. So what should you look for when choosing one? » Article: Training company uk |
» Forum post: VB |
» Tip: Compare two documents Word |
How do you take out a particular function in a macro using the editor if you have made a mistake
By using the Compare Side by Side feature in Word, you can compare the content of two documents easily.
