Excel SIGN Function
Summary
The Excel SIGN function returns the sign of a number as +1, -1 or 0. If number is positive, SIGN returns 1. If number is negative, sign returns -1. If number is zero, SIGN returns 0.
Purpose
Get the sign of a number
Return value
One if positive. Negative one if negative. Zero if zero.
Syntax
=SIGN (number)
Arguments
- number - The number to get the sign of.
Version
Usage notes
- If the number is in the range (-∞,0) SIGN(number) will return -1.
- If the number is equal to 0 SIGN(number) will return 0.
- If the number is in the range (0,∞)(number) SIGN will return 1.
Download 200+ Excel Shortcuts
Get over 200 Excel shortcuts for Windows and Mac in one handy PDF.
