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 the total keeps coming up with £29.10 but it should be £00.00 I'm fairly new with excel and only done a few basic courses please can any one help with what I'm doing wrong
3 Replies
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
Hey Anthony-
Hope you're doing well. Try using the below formula. I have attached an example file for your reference.
- Doing well thanks. And thank you for your time to answer my question
