Excel Tricks : Hide Those %&@# Formula Errors

You are invited to have my FREE RSS Feeds or you may Subscribe to me via email for latest information in this website.

Just want to share some excel tips for you

Problem : You are making a calculation on Your 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 my contact links.

Email This Post

; Filed Under Microsoft Excel

If you are new here, and you would like be updated on the things happening on this site, Try to Subscribe to my FREE RSS Feeds and Subscribe to me via email

« Previous post in category: Excel Tip : What If You forget your Excel Sheet Password ?

Tags:

Trackback Links