Using Excel ABS Function will give you an absolute number. In simple words, it will convert a negative number into a positive number.
In above example, to get positive numbers I have used this function. It has just removed the negative sign from the numbers.
- number A number or value to get a positive number of.
More Information on ABS Function
- You can also use this absolute function as an array function.
- You can also put the number in the function to get the positive number.
- If specify a number which is not an integer, it will return #VALUE!.
In the below example, I have used ABS function to get absolute values against the change in the interest rate.
You can use this function when a sign of the number is not so important.
To learn more about Excel ABS Function you can check Microsoft’s Help Section. And, if you have a unique idea to use it, I would love to hear from you.