Table of Contents
The SIGN function in Google Sheets is a mathematical function that can be used to determine the sign of a number. This function will return 1 if the number is positive, -1 if the number is negative, and 0 if the number is zero. To use the SIGN function, simply enter the function name in a cell, followed by the number or cell reference in parentheses. This will provide a quick and easy way to determine the sign of a number within your Google Sheets spreadsheet.
SIGN
Given an input number, returns `-1` if it is negative, `1` if positive, and `0` if it is zero.
Sample Usage
SIGN(-42)
SIGN(A2)
Syntax
SIGN(value)
value– The value whose sign will be evaluated.
Examples
[wpcc-iframe height=”300″ src=”https://docs.google.com/spreadsheet/pub?key=0As3tAuweYU9QdG5raDgyb1RmaUlkbVBkMnhpV2sxcEE&output=html” width=”500″]
Cite this article
stats writer (2024). How do I use the SIGN function in Google Sheets?. PSYCHOLOGICAL SCALES. Retrieved from https://scales.arabpsychology.com/stats/how-do-i-use-the-sign-function-in-google-sheets/
stats writer. "How do I use the SIGN function in Google Sheets?." PSYCHOLOGICAL SCALES, 30 Jun. 2024, https://scales.arabpsychology.com/stats/how-do-i-use-the-sign-function-in-google-sheets/.
stats writer. "How do I use the SIGN function in Google Sheets?." PSYCHOLOGICAL SCALES, 2024. https://scales.arabpsychology.com/stats/how-do-i-use-the-sign-function-in-google-sheets/.
stats writer (2024) 'How do I use the SIGN function in Google Sheets?', PSYCHOLOGICAL SCALES. Available at: https://scales.arabpsychology.com/stats/how-do-i-use-the-sign-function-in-google-sheets/.
[1] stats writer, "How do I use the SIGN function in Google Sheets?," PSYCHOLOGICAL SCALES, vol. X, no. Y, ص Z-Z, June, 2024.
stats writer. How do I use the SIGN function in Google Sheets?. PSYCHOLOGICAL SCALES. 2024;vol(issue):pages.