Changing error reports in functions

S

SupperDuck

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,
 
D

David Biddulph

Or, if you want to output 1 specifically for #DIV/0, rather than just for
errors in general:
=IF(ISNA(A1),"Error",IF(ISERR(A1),IF(ERROR.TYPE(A1)=2,1,A1),A1))
 
Top