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 |



Course updates

