changing the message in an error message

[The Villages DA]

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.

 

[Bernie Deitrick]

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

 

[dominicb]

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" rathe
than the type of error. If the formula can be calculated without error
it will.

HTH