In **Microsoft Excel**, the **SIGN** number is a math and trigonometry function that returns the sign of a number. The SIGN function returns 1 if the number is positive, zero if the number is 0, and -1 if the number is negative.

### What is Excel Sign formula?

The formula for the SiGN function is SiGN(number). The syntax for the Sign number is below:

**Number**: Any real number. It is required.

## How to use the Excel SIGN function

Follow the steps below to use the SGN function in Excel:

- Launch Microsoft Excel.
- Create a table or use an existing table from your files.
- Place the formula into the cell you want to see the result.
- Press the enter Key.

Launch **Microsoft Excel**.

Create a table or use an existing table from your files.

Place the formula *=SIGN(A2)* into the cell you want to see the result

Press the Enter key to see the result.

Drag the fill handle down to display the result for the other numbers in the table.

There are two other methods to use the SIGN function.

**Method one** is to click the *fx* button on the top left of the Excel worksheet.

An **Insert Function** dialog box will appear.

Inside the dialog box in the section, **Select a Category**, select *Math and Trigonometry *from the list box.

In the section **Select a Function**, choose the *SIGN *function from the list.

Then click *OK.*

*A Function Arguments dialog box will open.*

In the **Number** entry box, input into the entry box cell* A2.*

Then click* OK.*

*Method two* is to click the **Formulas **tab, then click the *Math and Trigonometry *button in the *Function Library* group.

Then select *SIGN *from the drop-down menu.

A **Function Arguments** dialog box will open.

**Now read**: How to create a Bar or Circle Progress Chart in Excel

We hope this tutorial helps you understand how to use the SIGN function in Microsoft Excel.