# SIGN

## Content

This function returns the sign of a number or expression.

## Syntax

`SIGN(cellreference)`

`SIGN(value)`

`SIGN(expression)`

## Arguments

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.

## Data Types

Accepts numeric data. Returns numeric data.

## Examples

`SIGN(B3)`

`SIGN(R1C2)`

`SIGN(-5)` gives the result -1

`SIGN(15-8)` gives the result 1