What is EXCEL ABS FUNCTION
The Excel ABS Function is listed under Microsoft Excel’s Maths Functions category. It returns a number after converting it into an absolute number. In simple words, converting a negative number into positive and unaffecting the positive number. In simple words, it returns a number without a sign.
How to use it
To learn how to use ABS function in Excel, you need to understand its syntax and arguments:
Syntax
ABS(number)
Arguments
- 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!.
Example
To master the ABS function we need to try it out in an example, so make sure to check out the below one: In the below example, we have used ABS 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.
Sample File
Make sure to check out this Basic Excel Tutorial, this is a guide that will help you to get started with Excel, and after that, here we have a list of EXCEL TIPS to make you an advanced Excel user in no time.
Related Functions
This tutorial is the part of our Excel Functions with Examples (Function Guide) and below are some of the related functions:
- Excel EVEN Function
- EXCEL INT Function
- EXCEL MOD Function
- EXCEL MROUND Function
- EXCEL RAND Function
- EXCEL SUM Function
- EXCEL SUMIF Function
- EXCEL SUMIFS Function
- EXCEL SUMPPRODUCT Function
- EXCEL TRUNC Function
About the Author
Puneet is using Excel since his college days. He helped thousands of people to understand the power of spreadsheets and learn Microsoft Excel. You can ﬁnd him online, tweeting about Excel, on a running track, or sometimes hiking up a mountain.