Hi rdmdale,

Pls try this

=IF(B2A2,B2-A2,A2-B2)

Anirudh

"rdmdale" wrote:


I'm making a worksheet for my company. I want to subtract one number
number from another number. I use the 'sum' format for this
'=sum(BL4-BP4) '. This format works fine for me in most cases, if
BL4 BP4. However, if BL4<BP4, the sum that is shown is a negative
number. I would like for the worksheet to show only positive numbers. I
would like for the cell to show ' 0 ' , or nothing at all, if the sum is
a negative number. For instance, 10-8=12 is ok, but 8-10=-2 is not. How
do I do this? Thanks


--
rdmdale
------------------------------------------------------------------------
rdmdale's Profile: http://www.excelforum.com/member.php...o&userid=27339
View this thread: http://www.excelforum.com/showthread...hreadid=468481