# SIGN

Determines the sign of a number, the result of a calculation, or a value in a column. The function returns 1 if the number is positive, 0 (zero) if the number is zero, or -1 if the number is negative.

## Syntax

```
SIGN(<number>)
```

### Parameters

Term | Definition |
---|---|

number | Any real number, a column that contains numbers, or an expression that evaluates to a number. |

## Return value

A whole number. The possible Return values are 1, 0, and -1.

Return value | Description |
---|---|

1 | The number is positive |

0 | The number is zero |

-1 | The number is negative |

## Example

The following formula returns the sign of the result of the expression that calculates sale price minus cost.

```
= SIGN( ([Sale Price] - [Cost]) )
```