Hide ugly errors in Excel

If your Excel formula returns an error, you usually end up with something rather unattractive like #VALUE! in the Cell. If you want to hide this from your users, you can simply drop your formula into this IF statement...

=IF(ISERROR(YourFormula),"",YourFormula)

The IF statement looks for an error in your formula. If it finds one, it blanks the cell. Otherwise, it puts the result of your formula.

For example, if your formula was A2*B6, you would write....

=IF(ISERROR(A2*B6),"",A2*B6)