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.

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 wrote in
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.


--
dominicb
------------------------------------------------------------------------
dominicb's Profile: http://www.excelforum.com/member.php...o&userid=18932
View this thread: http://www.excelforum.com/showthread...hreadid=346803