Using a negative figure as positive

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

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?
 
Negative number in A1

=A2-A1

will be the same as =A2+A1 with a positive number in A1
 
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
 
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
 
Back
Top