What is the use of Excel ABS Function
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 absolute function in excel. It has just removed the negative sign from the numbers.
Syntax for Excel ABS Function
number A number or value to get a positive number of.
More Information 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!.
Examples for ABS Function
In above example, I have used ABS formula 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.
Download Sample File
Excel ABS Function is helpful when you want to calculate variance by ignoring negative & positive signs. Learn more about ABS Function from here.