98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » IFERROR analysis
IFERROR analysis
Resolved · High Priority · Version 2007
Mon 5 Jul 2010, 16:57Delegate Fagbemi said...
Fagbemi has attended:
Excel Intermediate course
Excel Advanced course
IFERROR analysis
in what kind of situation do we look IFERROR?
Wed 7 Jul 2010, 18:48Trainer Anthony said...
RE: IFERROR analysis
Hi Faqbemi, thanks for your query. You can use IFERROR to trap all those unfriendly error messages you get on your spreadsheet such as VALUE and REF. Instead of those messages being generated you can test for the error and then generate a different response. This thread provides a few useful live examples of the IFERROR function:
http://blogs.techrepublic.com.com/msoffice/?p=443
Hope this helps,
Anthony
Wed 14 Jul 2010: Automatically marked as resolved.
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Find cells that match a formatIn Excel you may wish to find cells that contain a specific formatting such s colour. |
