How to do Math in a Google Sheets

One of the most useful things that one can do with Google Sheet is mathematics. The math done in a Google sheet is addition, sum, subtraction, multiplication, division, and square. Doing math in Google Sheet is easy if you know the right symbol to work with.

Follow the steps

1. Open the spreadsheet.

2. Type an equal’s sign in a cell (=).

3. Type a number or a cell that contains a number.

4. After use one of the indicated operations in mathematics – (subtraction), + (plus), *(multiply), / (divide).

5. Type another number or the cell reference.

6. Press enter.

The mathematical formulas in google sheet

The additional formula is in google sheets.

Addition by, using cell references


Addition of numbers without cell references


Addition by, using the ADD function


Sum formula in google sheets


The subtraction formulas in google sheets

Subtract by use of cell references.


Subtract numbers without cell references


Subtraction of numbers using the Minus function.

=minus (800,200)

Multiplication formulas in google sheets

Multiplying by use of cell references


Multiplication of numbers without cell references


Multiplication by using the multiply function


Division formulas in google sheets

Division by using cell reference


Division of numbers without cell references


Division by using the DIVIDE function


Square formulas in google sheets

Square by using the cell references


Square numbers without cell references


The square numbers using the POWER function



Square root formulas in google sheets

Square root by the use of cell references


Square roots numbers without cell references


The mathematical operations in spreadsheet

Plus sign (+)

Minus sign (-)

Asterisk (*)

Forward slash (/)

Carrot (^)

The mathematical functions in spreadsheet

=ADD ( addition)

=MINUS ( subtraction)

=MULTIPLY ( multiplication)

=DIVIDE ( division)

=SUM ( summing)

=POWER ( the exponent/ the power)

=SQRT( square root)

On the other hand, there exist the orders of operations in the spreadsheet

The order of operations in the spreadsheet

P( Parentheses)






Sample operations







In the application of the formulas, they enable cell multiplication quickly.

If you need to apply calculations in your spreadsheet to multiple cells easily and quickly, two options can be applied.

1st Option: copy-pastes the same formula into the cells below when you have already entered the math formula in the cell. It occurs in the rows. The formula will be copied into each cell. Furthermore, there is an automatic adjustment of the cell references if they are present.

2nd Option: Here, you can apply the formula function in the making of the mathematical formulas and operations in more than one cell. This formula is called The ARRAY FORMULA; this is applicable in multiple cells or even the whole column.

Leave a Comment