Something along the lines of
=IF(B1<0, A1/B1,"")
or
=IF(ISERR(A1/B1),"",A1/B1)
--
Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)
"Beep Beep" wrote in message
...
Can't remember the formula for not showing DIV/? error message when
dividing
by zero