Switching The Sign of a Cell Value
Note
- The Switch Sign option returns a positive cell value as negative and a negative cell value as positive for display purposes. Any cell calculations referenced will not take the switch sign into consideration and will use the original cell value.
- If both Flip Sign of Value and Switch Signs are selected, the cell will retain its original value while any calculations referenced to the cell will take into account the opposite value of the cell.