Menu
I know that with ABS() you can convert negative numbers to positive numbers.
But with what function do you convert a positive number to a negative number?
Is there even any?
592
An absolute value function (without domain restriction) has an inverse that is NOT a function. That's why by “default”, an absolute value function does not have an inverse function (as you will see in the first example below).
You can apply the Multiplication (*) operator as the opposite of the ABS function in Excel. Here, with this formula, you can convert the positive values into negative ones. On the other hand, the negative values will turn into positive ones.
-ABS(x)
e.g.
select -abs(123),-abs(-123)
-abs(123) -abs(-123)
--------- ----------
-123 -123
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
