Back to Functions

UMINUS

Returns a number with the sign reversed.

OperatorUMINUS(value)

The UMINUS function in Google Sheets is a powerful tool to return a number with the sign reversed. Whether you're working with positive or negative numbers, the UMINUS function simplifies the task. Dive into our comprehensive guide to master its application.

Parameters

  • value: The number you want to reverse the sign of.

Step-by-Step Tutorial

  1. Using UMINUS with an individual number:
    • Example: =UMINUS(5)
    • Result: -5

Use Cases and Scenarios

  1. Change Sign: Reverse the sign of a specific number.
  2. Calculations: Perform mathematical calculations involving negative numbers.

Related Articles

Newsletter

More UMINUS examples coming soon.

We are building short, practical updates for Sheets power users.