| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Columns negative to positive
If you have a column of negative and positive numbers, how do you transfer
these numbers all to be positive in the next column? FC |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Columns negative to positive
One way:
A1 = -10 Formula in B1: =ABS(A1) Returns 10 -- Biff Microsoft Excel MVP "UniStudent Coll" wrote in message ... If you have a column of negative and positive numbers, how do you transfer these numbers all to be positive in the next column? FC |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Columns negative to positive
If the numbers in the first column are in A1:A100, then in B1 put the
formula =ABS(A1) and drag it down to B100. Tyro "UniStudent Coll" wrote in message ... If you have a column of negative and positive numbers, how do you transfer these numbers all to be positive in the next column? FC |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Some Positive, Some Negative | Excel Worksheet Functions | |||
| Turning a negative into a positive | Excel Worksheet Functions | |||
| formula for negative and positive numbers in different columns | Excel Worksheet Functions | |||
| IF positive/If negative???? | Excel Worksheet Functions | |||
| Formula to make Negative Values Positive & Positive Values Negative? | Excel Discussion (Misc queries) | |||
![UniStudent Coll[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
