Forum Discussion
Accounting
Hi please can anyone help in excel i have one cell set up to subtract another but it's not coming up with the right answer why? Here is what I have £14.55 in one cell and -£14.55 in another cell but t...
Remember that if you subtract a negative value, you're summing it: A - (-B) = A + B
That's why your result is not zero.
Attention if the Value2 in that sheet is negative!
edit: doublepost https://techcommunity.microsoft.com/t5/Excel/Please-help/m-p/204476#M6667