• Subcribe to Our RSS Feed

Excel Tricks : Hide Those %&@# Formula Errors

Feb 25, 2007 by     No Comments    Posted under: microsoft excel, Tips and Tricks

Errors in Microsoft excel may sometimes occurs while doing calculation, such us multiplying a word to a number, and many more, This post will help you to drop the unwanted characters that will result to errors in calculation, But you have to use this trick with caution. I recommend using this trick for Excel Advance users rather that Microsoft excel new user.
Commonly Used Alt Keys (Shortcut) in Microsoft Excel

Below is another Excel Tricks

Problem : You are making calculation on Your Microsoft Excel Sheet and suddenly when you remove your Fixed Values, Your calculated answers returns the value ( #VALUE or #DIV/0 ). This is because a certain number ort any number has been divided by Zero.

Solution : You have to use the function ISERROR

ISERROR Returns TRUE if the value is any error value

Syntax : =IF(ISERROR(Original Formula),””,(Original Formula))

Sample : =if(iserror(B4*C4),””,(B4*C4))

Conclusion : This means that if B4*C4 will result to an invalid mathematical Calculation the answer will be null ( or blank )

Hope this Tricks Helps You. If you have some question in excel email me at Techathand [at] gmail [dot] com

You may check my other post about Microsoft Excel below :

Got anything to say? Go ahead and leave a comment!

XHTML: You can use these tags: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>