Formulas > =UMINUS()
How to Use UMINUS() in Google Sheets
Description
How To Actually Use UMINUS() in Sheets
UMINUS(value)
Try UMINUS yourself
In cells A1:A10, enter some positive and negative numbers. Use the UMINUS formula to reverse the signs of the numbers in A1:A10 and display the results in B1:B10.
Hints (2)
-
Remember to apply the formula to each cell in the range.
-
You can drag the formula down to fill the other cells.
Looking for a video tutorial? Members can email me anytime! Check out the blogs below for more info on this formula. Or generate your formula. Find more formulas here at BetterSheets.co/formulas
More related tutorials
Transcript-matched member videos for UMINUS(). Click through to watch.
Google Sheet Basics - The Absolute Basics
Learn more about the UMINUS() formula:
Generate a UMINUS() formula for your needs
Describe your task in plain English and get a paste-ready formula that uses UMINUS(). 2 free AI generations, no signup. Members get unlimited use.
Generate a UMINUS() formula