Excel Function : SIGN

Download now!

Excel Function : SIGN

Category

Math and trigonometry

Description

Returns the sign of a number

Microsoft Excel Reference Page

https://support.office.com/en-us/article/SIGN-function-109c932d-fcdc-4023-91f1-2dd0e916a1d8

Syntax and Description of the SIGN Excel Function

The syntax for the SIGN function in Excel is: =SIGN(number) The number argument is the number whose sign you want to return.

About SIGN Excel Function

SIGN(number) The SIGN function returns the sign of a number. A positive number returns 1, a negative number returns -1, and zero returns 0.