Shares

# How To Use Excel ABS Function

## Quick Intro

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.

## Syntax

ABS(number)

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

## Examples

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.

## What’s Next?

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.

There are also you have RAND function which is highly useful like this. Apart from this, I have a list of excel functions and some real life formulas examples.