Name errors are not from failing to find a result, it's either bad spelling
or using add-ins or UDF functions without having installed them

N/A errors however can be fixed like

=IF(ISNA(lookup()),0,lookup())



--

Regards,

Peo Sjoblom
"Narendra Boga" wrote in message
...
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