Learn Programming and technology with ease @ developerpublish.com

HomeMicrosoft OfficeExcelSIGN Function in Excel

# SIGN Function in Excel

In this post, you will learn about a simple Excel Function â€“ SIGN Function, how to use it in your excel spreadsheet.

## SIGN Function in Excel

It SIGN Function returns the numbers 1, -1, and 0 according to the sign of the given number. If the number is positive the function returns 1, if a negative number -1 and if the number is zero the function returns 0.

Syntax

`=SIGN(number)`

The syntax has one argument

• number â€“ This holds the number for which we need to find the sign.

## How to use SIGN Function in Excel?

To start enter the numbers in the excel sheet. In a new cell enter the syntax and highlight the data to include it in the function.

Press enter to display the answer and use the fill handle to apply the function to the rest of the data.

Share:

### You May Also Like

#### SKEW.P Function in Excel

In this article, you will learn about the SKEW.P function, the formula syntax and usage of the function in Microsoft...

#### SKEW Function in Excel

In this article, you will learn about the SKEW function, the formula syntax and usage of the function in Microsoft...

#### RANK.EQ Function in Excel

In this article, you will learn about the RANK.EQ function, the formula syntax and usage of the function in Microsoft...
• Excel
• November 23, 2021