Turning a negative into a positive

T

thoughtcat

Is there a formula for turning a negative number into the same number,
but positive? i.e. -20 into 20, or -34627 into 34627.

Thanks
TC
 
P

Pete

You can use ABS( ), which takes the absolute value (or magnitude). You
can also multiply by -1, but if the other number is positive this would
become negative.

Hope this helps,

Pete
 
G

Gary''s Student

1. Put -1 in an un-used cell
2. Copy the cell
3. Select the cells you want to change and
4. Paste/Special and check the multiply button
 
A

Arla

If your value is in A1, then type =sum(A1-A1-A1)
And you will get the negative of the positive and vice versa.
 
Top