Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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
![]() |
|||
|
|||
![]()
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
![]() |
|||
|
|||
![]() 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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Font error message | Charts and Charting in Excel | |||
Pivot Table not valid error message when formatting data 'button'. | Excel Discussion (Misc queries) | |||
When saving a worksheet in excel message "document not saved" | Excel Discussion (Misc queries) | |||
error message ISBLANK | Excel Discussion (Misc queries) | |||
#num! error message | Excel Worksheet Functions |