How to use ABS Function in excel

Posted on: April 2, 2021 in Excel Functions , 11.8 K
blog img

Description

The Excel ABS function returns the absolute value of a number.

Negative numbers are converted to positive numbers.

This function does not affect positive numbers.

The absolute value of a number is the number without its sign( sign -/+).

Return value of Abs Function

Returns the absolute value of a number. The absolute value of a number is the number without its sign.

Syntax


=ABS(number)

Note

Note: =ABS (number):
The number must not contain any special character other than + or –

Arguments

Number – Required. Write the real number you want the absolute value.

Examples

Formula Description Result
=ABS(5) Absolute value of 5 5
=ABS(-10) Absolute value of -10 10
=ABS(C5) Absolute value of D5 Cell Value 75
=ABS($5) Absolute value of $5 #VALUE!

Share your thoughts

Your email address will not be published. All fields are required.

Related post

  1. How to Use XLOOKUP with Multiple Criteria in Excel

    While Excel’s XLOOKUP function does not natively support multiple criteria…

  1. How to Use XLOOKUP in Excel

    XLOOKUP is a versatile function in Excel used for performing…

  1. How to use LOWER Function in Excel

    Excel Lower Function Converts all uppercase letters in a text…

  1. How to use AVERAGE Function in Excel.

    This function calculates the average from a list of numbers.…

  1. How to use ADDRESS Function in Excel

    The ADDRESS function to obtain the address of a cell…

Popular post

  1. Eclipse IDE – Create New Java Project.

    Opening the New Java Project…

  1. How to start the project in android studio

    Android Studio Open the Android…

  1. How to use ACOSH function in excel

    The ACOSH function returns the…

  1. Complete Header tags in html – easy to learn

    H tags can be used…

  1. Best features in Python programme – easy to learn

    Python is the most widely…