Forum home » Delegate support and help forum » Microsoft Excel Training and help » IFERROR analysis

IFERROR analysis

ResolvedVersion 2007

Mon 5 Jul 2010, 16:57 Delegate 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:48 Trainer 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 courses

98.7 % recommend us

More live stats...

Training information:

Excel tip:

Generate randon numbers

Some types of analysis require you to use randomly generated numbers. You can also use randomly generated numbers to quickly populate an Excel spreadsheet. There's an easy function you can use to do this automatically. Here are a few of the ways you can use it:

Type =RAND() in a cell to generate a number between 0 and 1.
Type =RAND()*100 to generate a number between 1 and 100.

View all Excel hints and tips

IFERROR analysis

IFERROR analysis

RE: IFERROR analysis

Excel articles

Excel tip:

Generate randon numbers