First, =sum(BL4-BP4) doesn't make much sense. It needs only to be
=BL4-BP4

Next, to return a zero instead of negative, do this:

=IF(BL4<BP4,0,BL4-BP4)

OR

to return a "nothing at all" instead of negative, do this:

=IF(BL4<BP4,"",BL4-BP4)
(use 2 double quotations in place of the zero)


--
Cutter
------------------------------------------------------------------------
Cutter's Profile: http://www.excelforum.com/member.php...fo&userid=9848
View this thread: http://www.excelforum.com/showthread...hreadid=468481