Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
The Villages DA
 
Posts: n/a
Default 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.


  #2   Report Post  
Bernie Deitrick
 
Posts: n/a
Default

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.




  #3   Report Post  
dominicb
 
Posts: n/a
Default


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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Font error message Phil Hageman Charts and Charting in Excel 19 September 8th 06 09:28 PM
Pivot Table not valid error message when formatting data 'button'. MDW Excel Discussion (Misc queries) 0 January 27th 05 04:01 PM
When saving a worksheet in excel message "document not saved" Dave Peterson Excel Discussion (Misc queries) 0 January 25th 05 12:38 AM
error message ISBLANK Hans Excel Discussion (Misc queries) 4 January 12th 05 04:49 PM
#num! error message Brenda Excel Worksheet Functions 4 November 19th 04 04:55 AM


All times are GMT +1. The time now is 05:21 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"