| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How do I make #DIV/0! error message go away?
I have the following function in cell C86:
=(B86-B87)/ABS(B87) B86 value = .04 B87 value = 0 I am getting the following error message in cell C86: #DIV/0! How can I make the error message go away and in what cell would I place the new function/code? Thanks in advance for any help, yeto |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I make #DIV/0! error message go away?
Hi,
Am Thu, 4 Jul 2013 11:08:49 +0100 schrieb yeto: I have the following function in cell C86: =(B86-B87)/ABS(B87) B86 value = .04 B87 value = 0 I am getting the following error message in cell C86: #DIV/0! try: =IFERROR((B86-B87)/ABS(B87),"") or =IF(B87=0,"",(B86-B87)/ABS(B87)) Regards Claus B. -- Win XP PRof SP2 / Vista Ultimate SP2 Office 2003 SP2 /2007 Ultimate SP2 |
|
#3
|
|||
|
|||
|
Thank you -- I will give it a try. Thank you for taking the time to reply.
Quote:
|
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I make an error message pop up for a user? | Excel Programming | |||
| replace VBA run-time error message with custom message | Excel Programming | |||
| error message: compile error, argument not optional | Excel Programming | |||
| changing the message in an error message | Excel Worksheet Functions | |||
| How do I get rid of "Compile error in hidden module" error message | Excel Discussion (Misc queries) | |||
Linear Mode
