Use the SIGN function to determine the sign of a number (whether it's positive, negative, or zero).

The function returns 1 if the number is positive, -1 if the number is negative, and 0 if the number is zero.

## Syntax

**SIGN(number)**

The sign function has the following arguments.

Argument | Data type | Description |
---|---|---|

number (required) |
Number |
The number you want to determine the sign of. |

## Constraints

This function has no constraints.

## Examples

The following table shows some example formulas using the SIGN function.

You can enter values directly into your formula, or reference line items or list properties.

Formula | Description | Result |
---|---|---|

SIGN(Product.Sales) |
This example shows how you can include line items or list properties in your formula. In this example, the value of Product.Sales is 50. |
1 |

SIGN(100) |
The sign of 100 (a positive number). |
1 |

SIGN(0) |
The sign of 0 (zero). |
0 |

SIGN(-10) |
The sign of -10 (a negative number). |
-1 |