Thursday, August 11, 2016

SIGN Function (WS)

Description

The Microsoft Excel SIGN function returns the sign of a number. If the number is positive, the SIGN function will return 1. If the number is negative, the SIGN function will return -1. If the number is 0, the SIGN function will return 0.

Syntax

The syntax for the SIGN function in Microsoft Excel is:
SIGN( number )

Parameters or Arguments

number
The number that you wish to return the sign for.

Applies To

  • Excel 2016, Excel 2013, Excel 2011 for Mac, Excel 2010, Excel 2007, Excel 2003, Excel XP, Excel 2000

Type of Function

  • Worksheet function (WS)

Example (as Worksheet Function)

Let's look at some Excel SIGN function examples and explore how to use the SIGN function as a worksheet function in Microsoft Excel:
Microsoft Excel
Based on the Excel spreadsheet above, the following SIGN examples would return:
=SIGN(A1)
Result: 1

=SIGN(A2)
Result: 0

=SIGN(A3)
Result: -1

=SIGN(0)
Result: 0

=SIGN(2012)
Result: 1

=SIGN(-2012)
Result: -1