How To Use Excel ABS Function

    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.

    Use Excel ABS Function To Get Absolute Value

    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.

    Excel-ABS Function To Get Absolute or Positive Number

    You can use this function when a sign of the number is not so important.

    Sample File

    download sample file to learn more about this tips

    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.