Autumn Dreams Wrote:
I guess I did not make myself clear in my original post. I need a
formula
that If A1<=B1, A1-B1,0 and If A1=B1-A1,0. When I try this as an IF
formula
it comes back FALSE.

does this work

won't you always end up with a neg number?
Besides you are asking the same thing but want different results if
A1=B1 then A1-B1 if A1=B1 then B1-A1
How can this happen??


--
davesexcel


------------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=537159