Breadcrumbs

ABS

Definition

Returns the absolute value of a number.

Sample Usage 



Syntax
 
  
   
  
 


ABS(value)


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



Notes
 
  
   
  
 


    
 
  • 
  
    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.
 
  
   
  
 


   abs1.png   


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


   abs2.png   
 


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


   abs3.png   


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


   abs4.png   



 







 
There were errors rendering macro:

 
    
  
  • An unknown error occurred.
    •