Definition:

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

Syntax:

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

 

 

Error.

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