Excel Math Functions : ABS

Introduction to ABS Function

ABS Function returns a number after converting it into an absolute number. In simple words, converting a negative number into a positive and unaffecting the positive number (returns a number without a sign).

Checkout Online Absolute Number calculator

• Absolute Number Calculator Online
• Free Absolute Number Calculator Online

Download Sample file

Download Sample file for working with the tutorial.

Syntax of ABS Function

ABS(number)

Arguments in ABS Function

• number: A number or value to get a positive number of.

Notes

• You can also use the ABS as an array function.
• You can directly insert the number in the function.
• If you specify a number that is not an integer, it will return #VALUE!.

Tutorial of ABS Function in MS Excel

In the below example, ABS function is used to convert negative values into positive ones. 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.

Other Math Function in Microsoft Excel

Explore other math function in Microsoft excel. The list of all the math function available for everyday use is given below –

• ABS Function
• EVEN Function
• INT Function
• MOD Function
• MROUND Function
• RAND Function
• SUM Function
• SUMIF Function
• SUMIFS Function
• SUMPRODUCT Function
• TRUNC Function