Exceljet

Quick, clean, and to the point

Excel SIGN Function

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.

Excel foundational video course
Excel Pivot Table video training course
Excel formulas and functions video training course
Excel Charts video training course
Video training for Excel Tables
Dynamic Array Formulas