logical functions

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

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Logical Functions

Logical Functions

resolvedResolved · Low Priority · Version 2003

Kaya has attended:
Excel Advanced course

Logical Functions

What does the function Iferror do?

RE: Logical Functions

Hi Kaya

Thank you for your question

Iferror returns a value or formula if an error occurs in a particular cell

The function has 2 arguments; the first specifies the cell where the error might occur and the second the value to return when an error does occur.

An this example the word error is returned when an error occurs

=IFERROR(D4,"Error")


Hope this helps

Regards

Stephen

Tue 31 Mar 2009: Automatically marked as resolved.


 

Excel tip:

Moving between Worksheets without using the mouse

Use the 'Ctrl+PgDn' and 'Ctrl+PgUp' keys.

'Ctrl+PgDn' will move to the right and 'Ctrl+PgUp' will move to the left one worksheet at a time.

View all Excel hints and tips


Server loaded in 0.08 secs.