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

The ifferror function simply returns a particular value or formula if a given cell contains any of the following errors

NULL
DIV
VALUE
REF
NAME?
NUM!
N/A

The syntax is iserror(value, Value if true)

Value is the cell that contains the cell to check for an error, and value if true is the result if there is an error.

Regards

Stephen




 

Excel tip:

Difference between Two Dates

The DATEDIF function computes the difference between two dates. The DATEDIF function is as follows:

=DATEDIF (Date1,Date2,Interval)

Please note that Date1 must be less than (earlier) or equal to Date2

Please note that Interval must be one of the following codes: "d" (in days), "m" (in months), "y" (in years) expressed in quotes


View all Excel hints and tips


Server loaded in 0.08 secs.