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

How To Use in Sheets


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 for more videos and tutorials!

0Better Sheets Tutorials

No videos yet. Stay tuned!