Put an equal to sign (=) in the cell to start the formula.Select the cell where you want the result to appear (cell C2).To use a formula to subtract two cell values in Google Sheets, follow these steps: When you finish entering a formula in a cell, it performs the operations as soon as you press the return key.Īt this point, the result of the formula gets displayed in the cell, while the actual formula is displayed in the function bar when the cell is selected: Whenever you use a formula in a cell, it is displayed on the formula bar. In any case, a formula should always start with an ‘equal to’ sign (=). It can also be complex, consisting of a series of formula operators. The MINUS function is the simplest Google Sheet formula for subtraction: = 6 - 5 = A2 – B2 The values used in a formula can be numeric, or text values reference to cells or defined names.Ī formula can be simple, as the ones shown below, with just two variables and an operation. A formula consists of a combination of values along with one or more operations, like addition, subtraction, etc. Subtracting in Google Sheets Using a Simple FormulaĪ formula is just a statement that a user makes to perform a calculation. In this dataset, we want to subtract each Expenditure value (column B) from each Income value (column A) and put the resultant Balance in column C. To understand how to quickly subtract cell values in Google Sheets, we are going to use the following dataset: Out of all the options, this is the simplest subtraction Google Sheets function. Type the equal sign in the results cell.The easiest way to get the Google Sheets difference between two numbers is using the minus sign. That’s precisely why, out of all the different ways in which you can subtract on Google Sheets, we have chosen to highlight these methods. Both provide excellent ways to perform calculations and obtain results. Google Sheets and, more or less, all spreadsheet software thrive on functions and formulas. Learning How to Subtract in Google Sheets Wrapping Up Subtraction In Google Sheets.How Do You Subtract Fractions in Google Sheets?.How Do You Add and Subtract on a Spreadsheet?.How Do You Create a Subtraction Formula in Google Sheets? / How Do You Subtract Numbers in Google Sheets?.How to Subtract Multiple Cells in Google Sheets.How to Do Subtraction on Google Sheets Across Multiple Worksheets.How to Subtract Numbers in Google Sheets Using Arrays.How to Subtract Time and Date In Google Sheets.How to Do Subtraction in Google Sheets With the SUM Function.Subtracting in Google Sheets using the MINUS Function.Subtracting in Google Sheets Using a Simple Formula.Learning How to Subtract in Google Sheets.

Googl docs sum if