SheetFX
≡
<< Go back to all functions

UMINUS

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.

Function Syntax and Parameters

Syntax: UMINUS(value)

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