Exceljet

Quick, clean, and to the point

Excel ABS Function

Excel ABS function
Summary 

The Excel ABS function returns the absolute value of a number. Negative numbers are converted to positive numbers, and positive numbers are unaffected.

Purpose 
Find the absolute value of a number
Return value 
A positive number.
Syntax 
=ABS (number)
Arguments 
  • number - The number to get the absolute value of.
Version 
Usage notes 

For example, ABS(-3) returns a value of 3 and ABS(3) returns a value of 3, because the ABS function returns a number's distance from zero.

Download 200+ Excel Shortcuts

Get over 200 Excel shortcuts for Windows and Mac in one handy PDF.