If D5 is smaller then G5, then you should get a zero,
Which is *exactly* what you got.

Your formula is working correctly!

You just have to get your mind around your own formula.

=If(D5-G5<0,0,D5-G5)

D5 = 5
G5 = 10
5 - 10 = -5 Which is *less* then 0
Makes the first argument TRUE, so the return is 0.

--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


"smdettloff" wrote
in message ...

Unfortunately it's still not working. I put the formula in H5 and put
small numbers in D5 and G5 just to test it but I'm getting a result of
0 when I should be getting 5.00. I've tried to attach a screen shot.


+-------------------------------------------------------------------+
|Filename: CaptureWiz007.jpg |
|Download: http://www.excelforum.com/attachment.php?postid=3769 |
+-------------------------------------------------------------------+

--
smdettloff
------------------------------------------------------------------------
smdettloff's Profile:
http://www.excelforum.com/member.php...o&userid=26839
View this thread: http://www.excelforum.com/showthread...hreadid=400846