| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Reverse value in a column
You need a helper column so assuming you numbers are in column A type this in
B1 and drag down as required. =IF(A1<0,A1,A1*-1) Mike "rb" wrote: 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 | |||
| to reverse a column | Excel Worksheet Functions | |||
| Reverse order of numbers in a column | Excel Discussion (Misc queries) | |||
| 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
