Skip to main content



Returns the absolute value of a number.

Sample Usage



  • value - The number of which to return the absolute value.


  • If value is nonnumeric, ABS returns the #VALUE! error value.

Step 1.  To begin to use the ABS formula, start with the Excellentable you would like to edit.

Step 2 : Then type the ABS formula into the cell you have chosen to display the outcome:

Step 3 : Type in the complete ABS formula for a cell as shown below:

Step 4 : Excellentable will generate the outcome when hitting enter. 


User does not have sufficient privileges to access this Content
Learn More

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.