< Go Back

Excel SIGN Function

Excel sign function is a built-in function in excel that is classified as a Trigonometry or Mathematics function. It is one of the useful function of excel and also used along with IF function. It returns the sign of a number. The Sign function will return 1, if the number is positive. If the number has negative value, excel sign function will return -1. The Sign function will return zero when the number is zero.

The syntax of excel sign function is:

=SIGN(Number)

  1. Where ‘Number’ is the number whose sign is needed.
  2. Usually, it is the cell reference for the number being tested.

Example

In this example, I have added numbers in column B from B5: B10 to return the sign for in column C from C5: C10 correspondingly. As seen from the GIF representation, excel sign function returns +1 for a positive number, 0 for 0, and -1 for a negative number.

Figure 1. Example of Excel Sign Function

Notes

  • SIGN(number) will return 1, If the number is in the range (0,∞)(number).
  • SIGN(number) will return -1, if the number is in the range (-∞,0).
  • SIGN(number) will return 0, if the number is equal to zero.
Our customers love us!
“The expert was absolutely amazing and stuck with me the whole way through. They were polite, patient, seemed to want to genuinely help me and provided a solution that I would never have managed otherwise. I could not be more thankful for their support and solution. Thank you!” - - Chris T, in California
This blog is one way to figure it out. A 20 minute chat session with an expert is a better way.Get step-by-step guidance on your question

Leave a Comment

avatar