# SIGN

## Content

This function returns the sign of a number or expression.

## Syntax

`SIGN(cellreference)`
`SIGN(value)`
`SIGN(expression)`

## Arguments

[Required] Specify a cell reference, a numeric or text value, or an expression for the argument.

## Remarks

Returns 1 if the number is positive, 0 if the number is 0, and –1 if the number is negative.

## Examples

`SIGN(B3)`
`SIGN(R1C2)`
`SIGN(-5)` gives the result -1
`SIGN(15-8)` gives the result 1