For business users of Microsoft Excel Free guides and templates
Home >  Excel Help >  Excel Functions >  

Math and trigonometry

ABS Function

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

by Charley Kyd, MBA
Microsoft Excel MVP, 2005-2014
The Father of Spreadsheet Dashboard Reports



  • Number  Required. The real number of which you want the absolute value.

Applies To

Excel 2003 and above


You can download this example workbook here, along with all other example workbooks I've completed for this Excel help area.

Examples for Excel's ABS function

Other Help


Charley's SwipeFile charts

Free Excel Dashboards