UMINUS
TheUMINUS
formula returns the negative value of a given number. It is commonly used to reverse the sign of a positive number or to subtract a number from zero. The formula takes only one argument which must be a valid number.
 How to use
UMINUS
formula?  Examples of using
UMINUS
formula UMINUS
formula not working? Similar formulas to
UMINUS
Usage
Use the UMINUS
formula with the syntax shown below, it has 1 required parameter:
 value (required):
The value to be negated. Must be a valid number.
Examples
Here are a few example use cases that explain how to use theUMINUS
formula in Google Sheets.
Convert positive numbers to negative
By using UMINUS
, you can quickly convert positive numbers to negative. For example, if you have a list of sales figures and you want to reverse their sign to represent refunds, you can use =UMINUS(B2)
.
Subtract a number from zero
To subtract a number from zero, you can use UMINUS
with the number as its argument. For example, =UMINUS(10)
will return 10.
Common Mistakes
UMINUS
not working? Here are some common mistakes people make when using the UMINUS
Google Sheets Formula:
Missing value to negate
Make sure to include a value to negate as an argument.
Incorrect argument type
Make sure the argument for UMINUS is a number or a reference to a cell containing a number.
Using UMINUS instead of MINUS
UMINUS is an operator that negates a value, while MINUS is an operator that subtracts values. Make sure you are using the correct operator.
Not using parentheses
If you want to negate the result of a calculation, make sure to put the calculation inside parentheses before applying UMINUS.
Using UMINUS unnecessarily
If you want to display a negative number, you can simply type a minus sign before the number, rather than using UMINUS.
Related Formulas
The following functions are similar to UMINUS
or are often used with it in a formula:

ABS
The
ABS
formula returns the absolute value of a number. The absolute value of a number is the distance between the number and zero on a number line, regardless of whether the number is negative or positive. It is commonly used to convert negative numbers to positive numbers or to ignore the negative sign of a number in calculations. 
SUBTOTAL
The
SUBTOTAL
formula is a mathematical formula used to calculate a subtotal for a range of cells. It can perform different mathematical operations based on the function code specified as the first parameter. This formula is commonly used to calculate subtotals for a filtered range of cells. 
SUMIF
The
SUMIF
formula is used to add up values in a range that meet a specific criterion. It can be used to sum values based on text, numbers, or dates. The formula is most commonly used in financial analysis, budgeting, and data analysis.
Learn More
You can learn more about the UMINUS
Google Sheets function on Google Support.