The UMINUS function in Google Sheets returns a number with the sign reversed. It's the function form of the unary minus operator, useful when a formula needs an explicit function call rather than a leading - sign. Dive into our comprehensive guide to master its application.
Parameters
value: The number you want to reverse the sign of.
Step-by-Step Tutorial
-
Using
UMINUSwith a positive number:- Example:
=UMINUS(5) - Result:
-5
- Example:
-
Using
UMINUSwith a negative number:- Example:
=UMINUS(-8) - Result:
8
- Example:
Use Cases and Scenarios
- Sign Reversal: Flip the sign of a value pulled from another calculation or cell.
- Financial Calculations: Represent expenses as negative numbers by reversing sign on positive input values.
Related Functions
UPLUS: Returns a number unchanged; the function form of the unary plus operator.MINUS: Returns the difference of two numbers.ABS: Returns the absolute value of a number.