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,

Changing error reports in functions
 

SupperDuck

=IF(ISNA(A1),"Error",IF(ISERR(A1),1,A1))


Uses a simple example of A1, but you could equally replace the A1 with the
whole of your current formula.
--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
DTHIS
www.nickhodge.co.uk


"SupperDuck" wrote in message
...
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,

Changing error reports in functions
 

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))
--
David Biddulph

"Nick Hodge" wrote in message
...
SupperDuck

=IF(ISNA(A1),"Error",IF(ISERR(A1),1,A1))


Uses a simple example of A1, but you could equally replace the A1 with the
whole of your current formula.

"SupperDuck" wrote in message
...
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,