Cyrus,

You are missing some parenthesis from your first formula to incorporate
the ISERROR function.

=IF(ISERROR((B7-B6)/ABS(B6)),"",(B7-B6)/ABS(B6))

Cheers,

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=513700