| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Reverse value in a column
If I have a column with numbers and there are both positive and negative
numbers and I want to change all positive numbers to negative in one formula. I know how to change negative into positive. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Reverse value in a column
If you want to change +ve to -ve and leave the -ve unchanged, use =-ABS(A1)
If you want to change +ve to -ve and -ve to +ve, use =-A1 Copy the formula down the column. -- David Biddulph "rb" wrote in message ... If I have a column with numbers and there are both positive and negative numbers and I want to change all positive numbers to negative in one formula. I know how to change negative into positive. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Reverse value in a column | Excel Worksheet Functions | |||
| to reverse a column | Excel Worksheet Functions | |||
| HOW TO REVERSE THE ROW OR COLUMN HEADINGS | Excel Worksheet Functions | |||
| How to reverse the column name and row name? | Excel Discussion (Misc queries) | |||
| Reverse order in column | Excel Worksheet Functions | |||
Linear Mode
