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