Using a negative figure as positive

[Guest]

If a number is on the spread sheet as negative, but for another calculation
you want to use the number as a positive - is there anyway to do it?

 

[Peo Sjoblom]

Negative number in A1

=A2-A1

will be the same as =A2+A1 with a positive number in A1

 

[T. Valko]

Use the ABS function:

A1 = -10

=ABS(A1)

Returns 10

 

[Guest]

hi
yes. basicly... a double minus sign.
in cell a1.... =-(-5) will display a positive 5.
if a1 = -5 and b1 = 5 then in c1 = -a1*b1 = positive 25. if you remove the
minus sign in the formula in c1 you have =a1*b1 = negitive 25. the double
minus sign comes from the minus sign in a1 and the minus sign in c1.

regards
FSt1

 

[Guest]

Many thanks - made me think!

Negative number in A1

=A2-A1

will be the same as =A2+A1 with a positive number in A1


--

Regards,

Peo Sjoblom

 

[Peo Sjoblom]

I use that a lot when I copy and paste special and want to add negative
values,
however in a formula Biffs' solution is better


--

Regards,

Peo Sjoblom