Many times we need to change the sign (+)->(-) or (-)->(+) or inverse in active tab selection.
This can not be done by any future of google sheet.
This tool will help you to change the sign (+)->(-) or (-)->(+) or inverse in active tab selection.
CLICK HERE to Install the addon.
How to Open Functionality:
- First of all, open the Google sheet then go to Extension > Sutra Tools > Utilities > Change Sign like the below screenshot:
Use of Functionality:
- This Functionality is to use only the current tab Active selection range list.
- This functionality is use only numeric values.
- After clicking on Change Case it shows 3 more options:
- Positive(+): It will use to convert the positive number (+) to a negative number(-) in the active tab range list
- Negative(-): It will use to convert the negative number(-) to a positive number(+) in the active tab range list
- Inverse: It will use to convert a positive number(+) to a Negative number(-) and vice versa in the active tab range list.