iferror

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

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

Iferror

resolvedResolved · Low Priority · Version 2003

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 ?

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

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.


 

Excel tip:

Concatenating Results of Formulas

To concatenate the results of formulas simply add the "&" after the formula or function closing bracket.

function1(....)&function2(.....)

see example Creating a range of monthly payments as text.

View all Excel hints and tips


Server loaded in 0.08 secs.