Forum home » Delegate support and help forum » Microsoft Excel Training and help » Iferror

Iferror

ResolvedVersion 2003

Fri 24 Sep 2010, 15:42 Delegate Jo said...

Jo has attended:
Excel Intermediate course
Excel Advanced course
Access Introduction course

Iferror

Could you tell me in what situation you would use a iferror and also give a few examples and may be an exercise to do ?

Wed 29 Sep 2010, 13:52 Trainer Simon said...

RE: Iferror

Hi Jo,

Thank you for your question.

Please find a link enclosed to explain what the IFERROR function can be used for and an example.

http://office.microsoft.com/en-us/excel-help/iferror-function-HA001231765.aspx

http://blogs.techrepublic.com.com/msoffice/?p=443

I hope this helps.

Regards

Simon

Fri 1 Oct 2010, 12:42 Trainer Nafeesa said...

Will be marked as resolved in 5 days

Notice: This is an automated message. Due to inactivity, this forum post will be marked as 'resolved' if there are no further responses in the next 5 days.

Fri 8 Oct 2010: Automatically marked as resolved.

Training courses

98.7 % recommend us

More live stats...

Training information:

Excel tip:

Switch on smart tags – Excel 2007

In order to use smart tags, make sure they are turned on, to do this:
1. Click on ‘Microsoft Office‘ button and then click on ‘Excel Options‘.
2. Click on ‘Proofing‘ category and then click on ‘Auto Correct Options‘.
3. In the ‘Auto Correct‘ dialogue box appears, click the ‘Smart Tags‘ Tab.
4. Tick the boxes, next to the Smart Tags you wish to use in Excel

View all Excel hints and tips

Iferror

Iferror

RE: Iferror

Will be marked as resolved in 5 days

Excel articles

Excel tip:

Switch on smart tags – Excel 2007