Forum Discussion
DannyDonkey
Jul 01, 2021Copper Contributor
Swap number's sign
Hey everyone, Does it exist a formula that replaces a number value's sign with the opposite sign? English is not my native language, and I do not have any experience with using English mathemati...
- Jul 03, 2021
So far my only viable option is to multiply source cell by -1 like this:
=[source cell]*-1
This works well with my current calculator sheet, but for a future broader usage this wont work with algebraic expressions unless there is a way to make algebraic expression recognised by the application.
DannyDonkey
Jul 03, 2021Copper Contributor
So far my only viable option is to multiply source cell by -1 like this:
=[source cell]*-1
This works well with my current calculator sheet, but for a future broader usage this wont work with algebraic expressions unless there is a way to make algebraic expression recognised by the application.