How to use ABS Function in excel

Posted on: April 2, 2021 in Excel , Excel Functions ,

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 -/+).

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


=ABS(number)

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

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

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!