# SIGN function in Excel

> SIGN tells you which side of zero a number is on: 1 for positive, -1 for negative and 0 for zero.

Source: https://spreadsheetpractice.com/functions/sign · Updated October 28, 2026 · Formulas and results on this page were run by the Spreadsheet Practice formula engine on November 20, 2026

## Quick answer

- **What it does:** SIGN tells you which side of zero a number is on: 1 for positive, -1 for negative and 0 for zero.
- **Syntax:** `=SIGN(number)`
- **Most common use:** `=SIGN(C2-B2)` returns 1 (Up on last year: 1)
- **Available in:** Every current version
- **Category:** [Math functions](https://spreadsheetpractice.com/functions/category/math)
- **Returns:** 1, -1 or 0.
- **Google Sheets:** Works the same in Google Sheets.

## What it does

SIGN tells you which side of zero a number is on: 1 for positive, -1 for negative and 0 for zero. It turns a change into a direction (up, down or flat) that you can count, chart or turn into a label.

## Syntax

`=SIGN(number)`

| Argument | Required? | What it is |
|---|---|---|
| `number` | Required | The number or calculation to test. |

## Examples

Each result was calculated by running the formula on the sample sheet.

| Cell | Formula | Result | What it shows |
|---|---|---|---|
| D2 | `=SIGN(C2-B2)` | 1 | Up on last year: 1 |
| D3 | `=SIGN(C3-B3)` | -1 | Down on last year: -1 |
| D4 | `=SIGN(C4-B4)` | 0 | No change: 0 |

### The sample sheet

Every formula above runs on this data:

|  | A | B | C | D |
|---|---|---|---|---|
| 1 | Month | Last year | This year | Direction |
| 2 | Jan | 420 | 455 | 1 |
| 3 | Feb | 390 | 372 | -1 |
| 4 | Mar | 410 | 410 | 0 |

## Common mistakes

| What you see | Why, and how to fix it |
|---|---|
| Got 0 when you expected a direction | The two values are equal, or both cells are empty (empty cells count as 0). Check the inputs. |
| You want words, not numbers | Wrap SIGN in CHOOSE: =CHOOSE(SIGN(C2-B2)+2,"Down","Flat","Up"). |
| #VALUE! | One of the cells holds text. Make sure both values are numbers. |

## Tips

- Count how many months grew: =COUNTIF(D2:D13,1).

## Related functions

- [ABS](https://spreadsheetpractice.com/functions/abs): ABS returns a number without its sign, so -250 becomes 250 and 250 stays 250.
- [IF](https://spreadsheetpractice.com/functions/if): IF checks a condition and returns one value when it is true and another when it is false.
- [CHOOSE](https://spreadsheetpractice.com/functions/choose): CHOOSE returns the item at a given position from a list you type into the formula: 1 returns the first item, 2 the second, and so on.

## Questions

### What does the SIGN function return for zero?

0. Positive numbers return 1 and negative numbers return -1.

### How do I show up or down labels from a change?

Use =CHOOSE(SIGN(C2-B2)+2,"Down","Flat","Up"), or an IF formula, or conditional formatting icon sets.

## Practice

A graded SIGN exercise ("Which way did prices move?") is on [the SIGN page](https://spreadsheetpractice.com/functions/sign). It is checked instantly, then re-checked on changed data.

---

Spreadsheet Practice (https://spreadsheetpractice.com) teaches spreadsheet formulas by practice: every exercise is graded in a live grid and re-checked on changed data.
