# Excel SIGN function

## Summary

The Excel SIGN function returns the sign of a number, indicating whether the number is positive, negative, or zero. It’s a straightforward function primarily used in mathematical, financial, and engineering calculations to determine the sign of a value.
##### Syntax
```				```
=SIGN(number)
```
```
• number: The number you want to find the sign of
##### Return value
1 if the number is positive, -1 if the number is negative, and 0 if the number is zero.

## How to use

Use the SIGN function by simply inputting the number for which you wish to determine the sign. This function is useful for understanding the nature of values in a dataset, especially when dealing with a mix of positive, negative, and zero values.

## Examples

##### Simple SIGN
Determining the Sign of a Number: To identify whether a number is positive, negative, or zero:
```				```
=SIGN(-10)
```
```
This formula returns -1, indicating the number is negative.
Sign of Financial Returns: Using SIGN to determine profit or loss:
```				```
=SIGN(B2)
```
```
If B2 contains a financial return, this formula returns 1 for profit, -1 for loss, and 0 for break-even.
##### SIGN with IF
Categorizing Data Based on Sign: Assigning categories based on the sign of values:
```				```
=IF(SIGN(A2)=1, "Positive", IF(SIGN(A2)=-1, "Negative", "Zero"))
```
```
This formula categorizes the number in A2 as “Positive”, “Negative”, or “Zero”.