Note: IFERROR function is only available in Excel 2007, otherwise you need to
use ISNA as Peo suggests, or ISERROR/ISERR

"OssieMac" wrote:

Lookup iferror function in help. An example is:-

=4/0 will return #DIV/0!

Put in as =IFERROR(4/0,0) returns 0

Regards,

OssieMac

"Narendra Boga" wrote:

hi all...

I have been working with various functions in Excel. If any function fails
to retrive the result, the cell displays #NAME? or #N/A. or something
denotes Error.

But I need "0" display instead of the above error messages. When a Function
fails or not correct the funtion the cell should display "0"(zero).

Have any setting??..

please help me..

Thanks
Narendra