Forum Discussion

anthony salmon's avatar
anthony salmon
Copper Contributor
Jun 14, 2018

Please help

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

1 Reply

  • It's math: A - (-B) = A + B

     

    To reach your result you have to SUM A and B.

Resources