## What is SIGN function in Excel?

The **SIGN **function is one of the math functions of Excel.

It Returns **the sign of a number**, **1** if the number is positive, **zero **if the number is zero, and **-1** if the number is negative.

We can find this function in **Math & trig** category of insert function Tab.

## How to use SIGN function in excel

- Click on
**an empty**cell (like F5 )

2. Click on the **fx icon** (or press shift+F3)

3. In the **insert function tab** you will see all functions

4. Select **math and trig** category

5. Select **SIGN **function

6. Then select **ok**

7. In the function arguments Tab you will see ** SIGN **function

8. Number section is any **real number**

9. You will see **results **in the formula result section

## Examples of **SIGN** function in Excel

**Example 1:**

**How to use SIGN function in excel**

You can see examples of SIGN function below:

**sign**(1) ----->>>>answer is 1
**sign**(-1) ----->>>>answer is -1
**sign**(0) ----->>>>answer is 0
**sign**(-2) ----->>>>answer is -1
**sign**(2) ----->>>>answer is 1

## What is the purpose of **SIGN** function?

**SIGN**

It Returns **the sign of a number**, **1** if the number is positive, **zero **if the number is zero, and **-1** if the number is negative.

## What is the Return value of **SIGN** function?

**SIGN**

It returns a number.

## How many arguments does **SIGN** function have?

**SIGN**

This function has just **1** Argument.

The **argument **of SIGN function is **number**.

Number section is any **real number**.

The argument of SIGN function is **required **and not optional.

```
SIGN(number) = number
```

## Which version of excel supports **SIGN** function?

**SIGN**

This function is available for all excel **versions **(2003-2019)

## Errors in **SIGN** function

**SIGN**