View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Narendra Boga[_2_] Narendra Boga[_2_] is offline
external usenet poster
 
Posts: 38
Default #NAME? and other results.

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