81% OFF online library of tutorials for mastering Google Sheets

One time purchase $199

Better Sheets
Create Free accountMember Login

SIGN()

Description

Given an input number, returns `-1` if it is negative, `1` if positive, and `0` if it is zero.

How To Use in Sheets

SIGN(value)

External Links

Absolute Value and Sign

Discover the Absolute Value and Sign functions. Select the HD quality option for the best full-screen viewing experience. Visit www.spreadsheetsolving.com for more videos and tutorials!

Google Docs Help

0Better Sheets Tutorials

No videos featuring this formula, yet. Stay tuned! In the mean time check out blogs below, and more formulas here at Better Sheets.