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,