How to Do Math Formulas in Google Sheets


While dealing with large set of data specifically numeric data, it’s hard to perform calculations for each and every entered data. But, why to perform such hectic task if we have too easy short formulas to calculate wide range of data. In your google sheets you can enter these formulas to performs all basic calculations such as additions, subtractions, multiplications and divide.

Any formula in google sheet (also called syntax) starts with = sign. These formulas can be put and calculations can take place by using two methods –‘ point and click method’  and ‘cell reference method.’

Point & Click Method

  1. Double click the cell where you want to perform the calculation.
  2. Press equals sign (=) from the keyboard.
  3. Now click on the first cell whose value you want to put in the formula first.
  4. Put in the math operator(+(Add), -(subtract),*(multiply) or /(divide) ) from your keyboard.
  5. Click on second cell you want in formula. Continue this till last cell that you want to include in formula.
  6. Press enter to get the calculations done.

Cell Reference Method

  1. Double click the cell you want to begin the formula with.
  2. Press = sign from keyboard.
  3. Type the cell reference/cell name. for example – A3
  4. Press the needed math operator
  5. Type the name of another cell, example A4.
  6. Press the enter key.

Now let’s learn to put formulas for these different calculation tasks with examples-

1                     A                         B
2Electric wires                      65
3Spinner                      45

Formula for Addition

  1. Double click the cell you want to begin the formula with.
  2. Press = sign from keyboard.
  3. Type the cell reference/cell name B2
  4. Press plus sign (+)
  5. Type the name of next cell i.e., B3.
  6. Press the enter key.
  7. Now with formula =B2+B3, the result in selected cell will be 105.

Formula for other calculations

Subtraction – = B2-B3

Multiplication – =B2*B3

Division – =B2/B3

Thus, similarly by using either of the abovementioned method, you can calculate your data without being traumatized about involvement of abundant numbers and calculations.

Harshita Mathur

My name is Harshita Mathur. I come from Jaipur, Rajasthan. I am a law student. Apart from this I am an amateur writer.

Recent Content