Leading the way in Microsoft Office Development
 Home|Excel|Word|PowerPoint|Consultancy|Feedback|Contact 
 Microsoft Excel > Functions > Maths and Trigonometry > ABS
 

ABS(number)

 
 Returns the absolute value of a number.

 numberThe number you want the absolute value of.

 REMARKS
 
  		• The absolute value of a number is just the number without its sign.
     
  		• If "number" is negative, this function simply removes the sign, returning a positive number.
     
  		• The "number" can be a cell reference or a named range.
     
  		• If "number" is not numeric, then #VALUE! is returned.

     EXAMPLES
     
     AB
    1=ABS(B1) = 1010
    2=ABS(B2) = 10-10
    3=ABS(B2-B1) = 20 
    4=ABS(-2.4) = 2.4 
    5=ABS(2.4) = 2.4 
    6=ABS(B2)-5 = 5 
    7=ABS(-0.036) = 0.036 
    8=SQRT(ABS(-16)) = 4 
    9=SQRT(ABS(16)) = 4 
    10=ABS(TRUE()) = 1 
    11=ABS(FALSE()) = 0 
    12=ABS("some text") = #VALUE! 
    		 
     Functions - A | Index - A | Office Online 

     Copyright © 2004-2007 Better Solutions Limited. All Rights Reserved.Top