Below is another Excel Tricks
Excel Tricks : Hide Those %&@# Formula Errors
Posted by : Dexter Panganiban |Welcome back! You might want to check my Archives and let me take this opportunity to invite you at my Make Money Online Personal Blog
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 Techathand [at] gmail [dot] com
Technorati tags: Excel Tips
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
- 10 Tips of Commenting in a Blog, A good style of Link Bait
- I Have Learn My Lesson on How to Earn from linking to Other Site
- How To Make Sure That Your post shows will show up in Trackback links ?
- DreamHost Promo Code { $50 Discount }
- Got Hacked Again
My WordPress Tips and Tricks
- How to import Blog Roll Links ?
- Do You Still Have Admin User ?
- Wordpress Plug-ins : Off Topic Post Off the Front Page
- Yahoo Shortcuts : Will it Boost my Blog ?
- Want Free WordPress Theme ?
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 )
