convert numbers to positive and keep delta value

N

nolenkw

I have a list of values that can be either negative or positive. I need them
all to be positive, but they need to maintain the relationship, or delta
value, to each other.
 
N

nolenkw

I'm afraid that does keep the relationship between the numbers. If I convert
a -1 to a 1, the the difference between that number and another number is not
maintanined.
 
D

David Biddulph

I'm afraid that does keep the relationship between the numbers. If I
convert
a -1 to a 1, the the difference between that number and another number is
not
maintanined.
Click to expand...

If all you're interested in is the difference, then try
=A1-MIN(A:A)
or if you don't want the lowest number to be zero & actually want it
positive, try
=A1-MIN(A:A)+1
 
Top