ABS function returns an absolute number. In simple words, it returns a number after removing its sign.

ABS(number)

*number**A number or value to get a positive number of.*

In the below example, to get positive numbers we have used ABS. It has just removed the negative sign from the numbers.

And here we have used ABS to get absolute values against the change in the interest rate.

Download this sample file from here to learn more.

- 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!.

*This function is the part of our **top 100 functions list** and here are some **useful formulas** which you can learn today.*

Related Functions

- EVEN Function: It returns a number by rounding it to the nearest even number.
- INT Function: It returns a number by rounding it to the nearest to the nearest integer.
- MOD Function: It returns remainder after dividing two numbers, not the result of the division of two numbers.

Related Tutorials

- Negative Number into Positive in Excel: So, this time I grabbed a paper and listed all the methods which I can use [...]
- Convert Formula to Value: All the methods which I've shared here are different in nature and [...]
- Add Serial Numbers in Excel: You can use these 14 different methods to add serial numbers a column [...]