Home > Random Post > Excel Tricks : Hide Those %&@# Formula Errors

Excel Tricks : Hide Those %&@# Formula Errors

Posted by : Dexter Panganiban on May 5, 2008 | ; Filed Under Random Post



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.

Related Posts
  • Excel Tricks : Hide Those %&@# Formula Errors
    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 ...
  • Excel Trick : What is the use of $ sign?
    Did you know "$" sign is an important part of excel formula? I would try to teach how you could use this sign. Problem : How can I fix the pick up point in one Excel Cell reference only? ( For this example it is Cell reference A1 ) See it here Technorati tags: Excel Tricks, Excel Tips, Microsoft...
  • Excel Tips : How to Make your Worksheet Name To Appear Into the Cell
    If you don't use Microsoft Excel forget just go to my other post :) Question : How to Make your Worksheet name to appear on your Microsoft Excel Sheet ? Answer : You can use the formula shown below, just copy and paste this formula in any of the cell where ou want to Worksheet name to appear. ...
Related Posts Plugin for WordPress, Blogger...

Enter your email address:

Tags: Excel, excel tips, Solution, tricks

About the author

Dexter is a person who loves technology,new gadget, SEO, Social Media and Christianity. Follow him at twitter via @techathand and add him @ Google+ and contact us at admin@techathand.net

Sign up for PayPal and start accepting credit card payments instantly.

Interesting Comments

Note : All Comment will be subjected to Tech At Hand Dot Net Comment Policy

Leave a Reply




Google+

My Sponsors

Help My Father's Kidney Dialysis Expenses

Help in My Father’s Kidney Dialysis by Contributing Articles and/or Being Our Link Builder

Subscribe to RSS feed

Subscribe to RSS feed

Enter your email address:

Categories