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