View Single Post
  #1   Report Post  
Linda
 
Posts: n/a
Default calculating results in formulas

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