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.