Hello,

I have a sum formula already in place. And by making some of the numbers negative, I am trying to subtract from the sum. Well, when I make the cell I want to subtract in the formula negative, it subtracts from the total BUT, double it’s value. Why?

E.g. Total = 10,000
-1000
= 8000 ???? instead of 9000

I guess the subtraction works as far as deduction. But, why is it doubling the value?

Hope you can help.
Thanks