| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
convert numbers to positive and keep delta value
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
convert numbers to positive and keep delta value
Could the absolute function be of help? =ABS(n) -- raypayette ------------------------------------------------------------------------ raypayette's Profile: http://www.excelforum.com/member.php...o&userid=29569 View this thread: http://www.excelforum.com/showthread...hreadid=570564 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
convert numbers to positive and keep delta value
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. "raypayette" wrote: Could the absolute function be of help? =ABS(n) -- raypayette ------------------------------------------------------------------------ raypayette's Profile: http://www.excelforum.com/member.php...o&userid=29569 View this thread: http://www.excelforum.com/showthread...hreadid=570564 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
convert numbers to positive and keep delta value
"nolenkw" wrote in message
... "raypayette" wrote: Could the absolute function be of help? =ABS(n) 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. 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 -- David Biddulph |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
