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