Table of Contents
The UMINUS function in Google Sheets is a mathematical function that allows users to find the negative value of a given number. To use this function, start by selecting a cell where you want the result to appear. Then, type “=UMINUS(” followed by the number or cell reference that you want to find the negative value of. Close the parentheses and press enter to see the result. This function can be useful for various calculations and data analysis tasks in Google Sheets.
UMINUS
Returns a number with the sign reversed.
Sample Usage
UMINUS(-4)
UMINUS(A2)
Syntax
UMINUS(value)
value– The number to have its sign reversed. Equivalently, the number to multiply by-1.
See Also
UPLUS: Returns a specified number, unchanged.
UNARY_PERCENT: Returns a value interpreted as a percentage; that is, `UNARY_PERCENT(100)` equals `1`.
Examples
[wpcc-iframe height=”300″ src=”https://docs.google.com/spreadsheet/pub?key=0As3tAuweYU9QdHJRaXE2WlRvVDRZakZIRkkwQk9nZ2c&output=html” width=”500″]
Cite this article
stats writer (2024). How do I use the UMINUS function in Google Sheets?. PSYCHOLOGICAL SCALES. Retrieved from https://scales.arabpsychology.com/stats/how-do-i-use-the-uminus-function-in-google-sheets/
stats writer. "How do I use the UMINUS function in Google Sheets?." PSYCHOLOGICAL SCALES, 30 Jun. 2024, https://scales.arabpsychology.com/stats/how-do-i-use-the-uminus-function-in-google-sheets/.
stats writer. "How do I use the UMINUS function in Google Sheets?." PSYCHOLOGICAL SCALES, 2024. https://scales.arabpsychology.com/stats/how-do-i-use-the-uminus-function-in-google-sheets/.
stats writer (2024) 'How do I use the UMINUS function in Google Sheets?', PSYCHOLOGICAL SCALES. Available at: https://scales.arabpsychology.com/stats/how-do-i-use-the-uminus-function-in-google-sheets/.
[1] stats writer, "How do I use the UMINUS function in Google Sheets?," PSYCHOLOGICAL SCALES, vol. X, no. Y, ص Z-Z, June, 2024.
stats writer. How do I use the UMINUS function in Google Sheets?. PSYCHOLOGICAL SCALES. 2024;vol(issue):pages.