Skip to main content



returns the sign (+1, -1 or 0) of a provided cellreference 


  • if the cellreference is positive, the function returns +1,

  • if the cellreference is negative, the function returns -1 

  • if the cellreference is 0 (zero), the function returns 0.


Step 1 : In order to use the SIGN formula, start with your edited Excellentable


Step 2 : Then type in the SIGN Formula in the area you would like to display the outcome:


Step 3 : Type in the complete SIGN 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


Other possible outcomes for the SIGN Formula:


  1. If the cellreference is positive

  2. If the cellreference is zero

JavaScript errors detected

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

If this problem persists, please contact our support.