So positive - positive is negative (regardless of true sign)?

And negative - negative is positive (regardless of true sign)?

What about positive - negative and negative - positive?

And why?

--
HTH

Bob Phillips

"Linda" wrote in message
...
I am trying to do some calculate differences between results in columns
containing a mix of negative or postive numbers. I can't seem to write
the
formula to display the results that are expected.

So far....I get the correct answer but all are postive results, and I can
add the minus sign, but then get only negative results. When summing the
answer columns results...then the difference is inflated.

For example: (0.33)-(0.37)=0.04 and 12.28-9.72=(2.56)

I would like the formula to take a negative number subtract another
negative
number and display the result as a positive AND the same formula to take a
positive number and subtract another postive number and display the result
as
negative.

Thanks for your help.
--
Linda