In Google Sheets, you can easily perform subtractions calculations by using the in-cell formula or the Minus function. Here, we have compiled easy-to-follow steps to apply such subtraction formulas in this article.
How to Subtract in Google Sheets?
It is possible to use an individual cell in Google Sheets as a calculator. You can use it to subtract one number from another following the method mentioned below. On PC You can perform complex calculations on sheets involving subtraction as well. If you have the equation, type it in after an “equals to” sign like the following example: =90-22x60(14-3) On Mobile App
Subtract One Column From Another
In cases where there are two columns with numbers, you can use the subtraction rule to subtract one from the other. You need to use the cell name in such a formula. Then, you can either use the Minus function or the subtraction formula. The method to perform such calculations are mentioned below.
For Single Cell
Here, C2 refers to the cell to be subtracted from, and D2 is the cell to subtract from C2. So, replace these values with the ones you want to subtract. You can also use the method mentioned below to perform such subtractions.
For the Whole Column
You can apply complex calculations to the process mentioned above. When solving equations like 5x-3y, you can replace x and y with the cell on your sheet. For C2 and D2, input =5C1-3D2 in the cell.
Subtract a Column From One Cell
For expense-related calculations, you may need to subtract multiple cells in a column from one cell with the total amount. You can follow the following method to perform such a calculation. On the given formula “=D7-SUM(D2:D6)”, D7 is the cell with the budget or the number to subtract from. Likewise, D2:D6 is the range to subtract from D7.
Other Subtraction Conditions
The normal formula for subtractions does not apply to conditions such as time, date, or percentages. You can apply condition-specific formulas for such calculations. The method to apply such formulas are mentioned below:
For Time
You can apply the subtracting formula to calculate the duration between two separate times. However, you need to follow the steps mentioned below to get the correct reading. In the condition mentioned above, E2 and D2 need to be in time formats, such as 1:00 PM or 5:00 AM. You can replace the formula in step three with =E2-(D2/24) if you want to subtract hours from time.
For Percentage
You can apply the subtraction formula to subtract tax, commission, discounts, or other similar numbers from other numbers on your cell. You can drag the cell with the formula to the bottom if you have multiple cells to apply this subtraction. You can click the small blue rectangle on the cell with the formula and drag it.
For Date
You can apply a subtraction formula to calculate the number of days or the duration between two dates. You can use the normal subtraction formula; =E2-D2, where E2 and D2 are the separate dates to subtract. Alternatively, you can use =Date(Year(B2),Month(B2),Day(B2)) functions to subtract years, months, or days on Sheets. Here, B2 is the cell with the date to subtract from. Then, you need to include -C2 after Year(B2) to subtract years, after Month(B2) for months, or Day(B2) for days.
