How to get rid of the error message? - KING OF EXCEL

Saturday, January 11, 2020

How to get rid of the error message?

How to get rid of the error message?

Image  Did you know…
there are 7 (+1 if you consider #### an error) types of error message in Excel?  In my experience, most users do not care about the meaning of the errors.  They just want them “disappear” on their worksheet because these errors do not look good.
IFERROR is a simple way to achieve this:
Instead of inputting your formula (e.g. =A1/0) directly, wrap it with IFERROR.

=IFERROR(Your formula,””)
For Excel 2003 or earlier user:
=IF(ISERROR(Your formula),””,Your formula)
Literally, it means IF the formula gives you an error result, then return nothing (“”), else return the result of the formula itself.
Tips: You may replace “” to any text or reference you want, e.g. “Zero/No denominator found”.
btw, if you are interested in learning more about the meaning of each error types, and probably how to avoid errors in building formula, check this site from MS.
#evba #etipfree #kingexcel
📤You download App installed directly on the latest phone here :

Popular Posts