ABS Function in Excel: Syntax, Examples and Free Practice
ABS is an Excel Math & Trig function. Returns the positive version of a number, ignoring its sign.
ABS syntax
=ABS(number)
Arguments
number: A number to use in the calculation
When to use ABS
ABS is used in financial models and engineering-style calculations where precise numeric work is needed.
Practice ABS online, free
Open the live Excel-style spreadsheet and try ABS yourself. No Excel install or sign-up needed to start.
Practice ABS now →More Math & Trig functions
Frequently asked questions
What does the ABS function do in Excel?
Returns the positive version of a number, ignoring its sign.
What is the syntax of ABS in Excel?
The syntax is =ABS(number). number: A number to use in the calculation.
Where can I practice ABS online for free?
Open the free live spreadsheet on Cellgrids and try ABS yourself. No Excel install is needed and you can start without signing up.
All Excel formulas · Cheat sheet · Excel exercises · Math and Trig functions · Excel case studies · Excel tutorials · Excel shortcuts