Google sheets offer various features and options enabling people to perform mathematical tasks and obtain correct results.
When you subtract numbers in real life, it’s a simple task because we have been taught to do basic mathematical calculations since our childhood. On top of that, the advent of calculators has made the task even easier.
Subtracting figures in Google sheets is a whole thing. It’s different from how we subtract numbers. Whenever you are dealing with large figures, it becomes impractical to use a calculator for every calculation. The process also consumes a lot of time.
The subtract function of Google sheets then comes into use. You can perform subtraction of large numbers together at one go. Google sheet uses functions and formulas to perform subtraction. If you don’t know how to get started, we have listed below two methods on how to subtract in Google sheets.
Steps to subtract in Google Sheets
- Select the cells or data you want to subtract. Here, we will subtract expenditure from income and display it in the remaining section
- In the cell C3, we will write the subtraction formula which will subtract expenditure from the income[ the Syntax for subtraction in Sheets is =MINUS(value1, value2) ]
- Hitting enter will subtract the values:
- Now, to apply the formula to all subsequent cells, just drag the cell by the blue box at the corner: