Return + value instead of -

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

In column A and B I have numbers that are summed in column C. Now some of the
numbers come out negative(as the result really is). I want to sum the numbers
in column C at the buttom, but the numbers not being negative( - in this
context it is indifferent whether they are positive or negative). I think I
read inhere something about a formula that will change the outcome, so that
all the numbers can be positive. Does anyone know that formula, or know how
to make them all positive?
Thanks a lot
 
just to keep trach of the numbers you may want to use a help column
in column D with the formula =abs(c1) and extend that down.
then sum column D
 
Back
Top