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

SIGN(number)

 
 Returns the numerical value indicating if a number is positive or negative.

 numberThe number you want the sign of.

 REMARKS
 
  		• If "number" > 0, then 1 is returned.
     
  		• If "number" = 0, then 0 is returned.
     
  		• If "number" < 0, then -1 is returned.

     EXAMPLES
     
     A
    1=SIGN(4) = 1
    2=SIGN(-2) = -1
    3=SIGN(0) = 0
    4=SIGN(-2*-1) = 1
    5=SIGN(10) = 1
    6=SIGN("some text") = #VALUE!
    		 
     Functions - S | Index - S | Office Online 

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