I think most of us will agree that error values can be helpful, and sometimes extremely unhelpful. For example, the #N/A error (Value Not Available error) is very helpful when cross-referencing two lists using the VLOOKUP function. If Excel can’t find a lookup value the #N/A error makes it very obvious.
However if you are wanting to total a range that includes #N/A errors all of a sudden they aren’t so special any more. Read more
PROBLEM: Generating random numbers.
SOLUTION: Let Excel do it for you!
PROBLEM: how do I hide errors in a worksheet? For example the #DIV/0 error or the #N/A error. Not only do they look not so great on the worksheet, they can cause other functions and formulas that include the cell holding the error to bring back an error as well (sigh).
SOLUTION: Start using the IFERROR function to hide the errors. Not only will it hide the errors in your workbook, your other calculations will no longer show errors. Read more