MINUS

The MINUS function in Google Sheets returns the difference between two numbers, functioning as the formula equivalent of the - operator. It's useful when you want subtraction expressed explicitly as a function, such as inside ARRAYFORMULA or when chaining functions together. Dive into our comprehensive guide to master its application.

Parameters

• value1: The number from which value2 will be subtracted.
• value2: The number to subtract from value1.

Step-by-Step Tutorial

1. Using MINUS with two numbers:

   • Example: =MINUS(10, 4)
   • Result: 6

2. Using MINUS with cell references:

   • Example: If A1 is 50 and B1 is 18, then =MINUS(A1, B1) returns 32.

Use Cases and Scenarios

1. Financial Calculations: Calculate the difference between revenue and expenses.
2. Inventory Tracking: Determine stock remaining after subtracting units sold from units received.
3. Array Formulas: Use MINUS inside ARRAYFORMULA where the - operator may not behave as expected.

Related Functions

• SUM: Returns the sum of a series of numbers.

Related Articles

• Top 4 Basic Arithmetic Functions Every Google Sheets User Should Know