Excel Tricks : Hide Those %&@# Formula Errors
Posted by : Dexter Panganiban |You are invited to have my FREE RSS Feeds or you may Subscribe to me via emailfor 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.
About the author
Dexter Panganiban : Dexter is a techie person that also blogs at his Personal Blog " Dexter Panganiban Site ", He is a Mechanical Engineer by Profession. He loves Search Engine Optimization and Making Money Online
Interesting Comments
Leave a Reply
Check my Blogging Tips and Experience
- How did I got # 1 from Google SERP in Manny VS Barrera fight result
- Do You Need to Provide All Information ?
- Digg’s count on your post?
- The freelancers toolset 100 web application for everything you will possibly need
- What should be your Blogging Routine ?
My WordPress Tips and Tricks
- Errors in Upgrading Wordpress 2.8 bleeding-edge
- WordPress Tips : How to Tweak Category Pages
- Blog Tips : Design Can Make an Impact to Your Blog
- WordPress 2.8 Beta is Out
- Top Web Hosts
My SEO Tips and Tricks
SEO Tips- A Big Thanks to Bloggista.com and Welcome New Readers
- Google October 2009 PR Update
- Factors for Search Engine Rankings
- Footer and Blog Roll Links Vs In Content Links
- PayPal Philippines Transaction Fees
- How To Change Wordpress Permalink
- Google Search Option Video and My Take
- An Interview at Phawville.com
- Chitika Says I am Expert in SEO
- What is Canonical Link Element
Affiliate Links
- SEO Tips
- Television | Great Source of Make Money Online Keywords
- Top Keywords that Brings Money to Us
- Basic Information about SEO | Search Engine Optimization
- SEO Thursday : Paypal Keywords
- How to Get A Proper Domain Name
- Flickr Could Increase Your Page Views and Visitors
- How to verify blogger blog on Google webmasters central tool
- Factors for Search Engine Rankings
- SEO Tips : Search Engine’s Factor from the Experts
- Footer and Blog Roll Links Vs In Content Links
My Supporters
Subscribe to RSS feed
Categories
- Categories
- Adsense Tips and Experience (RSS) (64)
- Blogging Tips and Experience (RSS) (179)
- Experiment (RSS) (15)
- Gadget (RSS) (124)
- How To (RSS) (9)
- Internet News (RSS) (121)
- Mobile (RSS) (62)
- Mom Gadget (RSS) (5)
- Problogging – Make Money Online (RSS) (55)
- Saudi Tech Stuff (RSS) (8)
- SEO ( Search Engine Optimization Tips ) (RSS) (99)
- Site Updates (RSS) (41)
- Tech Stuff (RSS) (66)
- Tips and Tricks (RSS) (61)
- Wordpress (RSS) (72)
Translator
By N2H - My Journal ( My Wife )
