Why do it twice? Obviously 11-10 is different to 10-11, it is a different
sum so it gives a different result.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Autumn Dreams" wrote in message
...
Thank you, but that only reflects one of the answers I need. If I do 2
columns with B1-A1 and the other A1-B1, I get to different answers showing
at
the same time. I need just one answer or zero to indicate they are equal.
ie If B is greater than A it's a positive (overage), if B is less than A
it's
a negative (shortage). Hope this explains what I need better. Thank you.

"Bob Phillips" wrote:

Surely it is just

B1-A1

or if you want a message

=IF(B1-A1=0,"No problem","Problem")

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Autumn Dreams" wrote in
message
...
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. This is for a cash over/under formula. For
instance
when you take in money at a restaurant, you find your cash over/under
by
totaling the sales receipts minus the credit card amounts. After you
remove
you starting amount of cash (cash drawer) from the total cash you
have, if
the remaining cash does not equal that amount you have a cash
over/short.
I
need a formula that calculates this. A being the amount of cash you
should
have and B being the amount you actually have. Thank you.