changing the message in an error message

When I copy and paste a formula into a cell that refers to a blank cell I get
and error message that say #div/01! and I want to change to ERROR.

How can I do that???

Thanks for the help.

Good evening

Use this formula:

=IF(ISERR(B1/A1)=TRUE,"ERROR",B1/A1)

This will work for any error (except #N/A) and will show "ERROR" rather than the type of error. If the formula can be calculated without error, it will.

HTH.

Re-write your formula:

=IF(ISERROR(Original Formula),"ERROR",Original Formula)

Where Original Formula is your current formula, but without the = sign.

HTH,
Bernie
MS Excel MVP

"The Villages DA" <The Villages [email protected]> wrote in
message news:[email protected]...
> When I copy and paste a formula into a cell that refers to a blank cell I
get
> and error message that say #div/01! and I want to change to ERROR.
>
> How can I do that???
>
> Thanks for the help.
>
>