# Google Sheets MINUS Function: Syntax, Examples & Tips - URL: https://betteranalyst.com/google-sheets/minus-function - Author: Better Analyst Formula Bot is now Better Analyst—same account, more powerful analysis.Formula Bot is now Better Analyst—same account and workflows, with more powerful analysis, dashboards, and automation. [Learn what changed](https://betteranalyst.com/formula-bot-is-now-better-analyst) Returns the difference of two numbers (value1 minus value2); the function form of the - operator. ``` =MINUS(value1, value2) ``` Generate FormulaExplain Formula One free generation or explanation per browser, shared across Excel and Google Sheets. Account usage limits apply afterward. Describe the MINUS you need in plain EnglishGenerate Formula ## Parameters | Parameter | Required | Description | | - | - | - | | **value1** | Yes | The number to subtract from (the minuend). | | **value2** | Yes | The number to subtract (the subtrahend). | ## What Is MINUS? MINUS subtracts one number from another. `=MINUS(A2, B2)` returns the same value as `=A2-B2`. Google Sheets has no SUBTRACT function — MINUS is the named form of subtraction. ## How MINUS Relates to the `-` Operator The minus sign does two jobs in a spreadsheet, and Google Sheets has a separate function for each: | Use of `-` | Example | Function equivalent | | - | - | - | | Binary subtraction (two values) | `=A2-B2` | `=MINUS(A2, B2)` | | Unary negation (one value) | `=-A2` | [=UMINUS(A2)](https://betteranalyst.com/google-sheets/uminus-function) | MINUS handles the first case only. Like the other operator functions, it takes **exactly two** arguments, so to subtract several values from one you need either chained operators (`=A2-B2-C2`) or a sum: `=A2-SUM(B2:D2)`. ## Basic Examples ### Simple subtraction ``` =MINUS(100, 35) ``` Returns 65. ### Profit ``` =MINUS(B2, C2) ``` Returns revenue in B2 minus costs in C2. ### Days between two dates ``` =MINUS(B2, A2) ``` Because dates are serial numbers, subtracting a start date from an end date gives the number of days between them. Format the result as a number, not a date, or you will see an odd date like 1/10/1900. ### Time elapsed ``` =MINUS(C2, B2) ``` With clock times in B2 and C2, the result is a fraction of a day. Format it as Duration to show hours and minutes. ## How MINUS Handles Inputs - **Blank cells** are treated as 0. `=MINUS(A2, B2)` with B2 empty simply returns A2. - **Booleans**: TRUE counts as 1 and FALSE as 0. - **Text that can't be read as a number** returns #VALUE!. - **Argument order matters**: subtraction is not commutative, so `MINUS(5, 3)` is 2 while `MINUS(3, 5)` is −2. ## Common Use Cases - **Variance analysis**: Actual minus budget. - **Profit and margin**: Revenue minus cost. - **Inventory**: Opening stock minus units sold. - **Date arithmetic**: Days remaining until a deadline (`=MINUS(E2, TODAY())`). - **Change over time**: This period minus the previous period. ## Common Errors - **Too many arguments**: `=MINUS(A2, B2, C2)` errors. Use `=A2-B2-C2` or `=MINUS(A2, SUM(B2:C2))`. - **Result shown as a date**: When you subtract dates, Sheets may inherit date formatting. Change the format to Number. - **Negative time**: Subtracting a later time from an earlier one gives a negative fraction, which can display oddly. If the period crosses midnight, use `=MOD(C2-B2, 1)`. - **#VALUE!**: An input contains text such as "$1,200 (est.)". Clean the value first. ## Tips and Best Practices - MINUS and `-` are interchangeable for two values. MINUS can make formulas easier to read aloud in documentation. - For the absolute difference regardless of order, wrap it: `=ABS(MINUS(A2, B2))`. - For the difference between dates in months or years, DATEDIF is more suitable than subtraction. - To subtract a percentage, multiply instead: `=A2*(1-B2)`. ## Related Functions ADD, [MULTIPLY](https://betteranalyst.com/google-sheets/multiply-function), DIVIDE, [UMINUS](https://betteranalyst.com/google-sheets/uminus-function), SUM, ABS, and DATEDIF. ## Example use case A department head tracks budget versus actual spend for each cost centre. Column D uses =MINUS(B2, C2) to subtract actual spend from budget, giving the remaining budget for each line; negative results immediately reveal overspending. ## Need more help with Google Sheets formulas? Sign up for Better Analyst and get unlimited AI-powered formula generation, explanations, and advanced data analysis. [Create Free Account](https://betteranalyst.com/signup)[Try Formula Generator](https://betteranalyst.com/excel-ai) ## Google Sheets how-to guides - [How To Combine Two Columns In Google Sheets](https://betteranalyst.com/google-sheets/how-to-combine-two-columns-in-google-sheets) - [How To Copy Formula In Google Sheets](https://betteranalyst.com/google-sheets/how-to-copy-formula-in-google-sheets) - [How To Count Unique Values In Google Sheets](https://betteranalyst.com/google-sheets/how-to-count-unique-values-in-google-sheets) - [How To Create A Pivot Table In Google Sheets](https://betteranalyst.com/google-sheets/how-to-create-a-pivot-table-in-google-sheets) - [How To Divide In Google Sheets](https://betteranalyst.com/google-sheets/how-to-divide-in-google-sheets) - [How To Enable Macros In Google Sheets](https://betteranalyst.com/google-sheets/how-to-enable-macros-in-google-sheets) - [How To Filter In Google Sheets](https://betteranalyst.com/google-sheets/how-to-filter-in-google-sheets) - [How To Find Circular References In Google Sheets](https://betteranalyst.com/google-sheets/how-to-find-circular-references-in-google-sheets) ## Explore all Google Sheets formulas Browse our complete library of Google Sheets formula guides Compare your options ## Decide with evidence, not a sales pitch. Open a neutral research prompt in the AI tool you already use. Compare capabilities, limitations, and fit before you choose. 1. [01ChatGPTOpen a balanced comparison prompt in ChatGPT.](https://chatgpt.com/?prompt=Compare%20Better%20Analyst%20with%20using%20a%20general-purpose%20AI%20assistant%20for%20data%20analysis.%20Evaluate%20spreadsheet%20and%20document%20analysis%2C%20dashboards%2C%20repeatable%20reports%2C%20code%20transparency%2C%20data%20connections%2C%20pricing%2C%20and%20limitations.%20Use%20current%20public%20sources%2C%20distinguish%20verified%20facts%20from%20assumptions%2C%20and%20explain%20which%20types%20of%20users%20each%20option%20fits%20best.) 2. [02ClaudeOpen the same research prompt in Claude.](https://claude.ai/new?q=Compare%20Better%20Analyst%20with%20using%20a%20general-purpose%20AI%20assistant%20for%20data%20analysis.%20Evaluate%20spreadsheet%20and%20document%20analysis%2C%20dashboards%2C%20repeatable%20reports%2C%20code%20transparency%2C%20data%20connections%2C%20pricing%2C%20and%20limitations.%20Use%20current%20public%20sources%2C%20distinguish%20verified%20facts%20from%20assumptions%2C%20and%20explain%20which%20types%20of%20users%20each%20option%20fits%20best.) 3. [03PerplexityResearch the comparison with linked web sources.](https://www.perplexity.ai/search?q=Compare%20Better%20Analyst%20with%20using%20a%20general-purpose%20AI%20assistant%20for%20data%20analysis.%20Evaluate%20spreadsheet%20and%20document%20analysis%2C%20dashboards%2C%20repeatable%20reports%2C%20code%20transparency%2C%20data%20connections%2C%20pricing%2C%20and%20limitations.%20Use%20current%20public%20sources%2C%20distinguish%20verified%20facts%20from%20assumptions%2C%20and%20explain%20which%20types%20of%20users%20each%20option%20fits%20best.) AI answers can be incomplete. Check source links, current pricing, and product documentation before deciding.