| Home |
| Search |
| Today's Posts |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Invert Negative number?
If by 'invert' you mean to negate negative numbers, use the ABS() function
then all conversions result in positive values. If you mean to swap positive for negative (or vice versa) use the suggested x = -x or X = X*(-1). Hope this helps |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Changing color of negative bar when using Invert if negative | Charts and Charting in Excel | |||
| change the colour of the "invert if negative" option in Excel | Charts and Charting in Excel | |||
| Change negative sign from end of number to the beginning of the number. | Excel Programming | |||
| 2003= negative number&2004= negative number How Do I Calculate gro | Excel Worksheet Functions | |||
| Compare/match positve number against negative number? | Excel Programming | |||
Threaded Mode
