View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
SupperDuck SupperDuck is offline
external usenet poster
 
Posts: 44
Default Changing error reports in functions

Hi,

I don't want to see the #N/A or #DIV/0! errors for the result of functions.

Do you know a way, for example if it is #N/A, i want to see "Error" writing
in cell. Or for #DIV/0! i want to see "1" in that cell.

Thank you for support,

Regards,