Doubling subtracted amount?
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
= 8000 ???? instead of 9000
I guess the subtraction works as far as deduction. But, why is it doubling the value?
Hope you can help.