# 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. 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

=A1+A2 Addition of numbers without cell references

=100+200

=SUM(A1:A7)

### The subtraction formulas in google sheets

Subtract by use of cell references.

=A1-A2 Subtract numbers without cell references

=800-200

Subtraction of numbers using the Minus function.

=minus (800,200) ### Multiplication formulas in google sheets

Multiplying by use of cell references

=A1*B1 Multiplication of numbers without cell references

=12*2

Multiplication by using the multiply function

=MULTIPLY(12,2) ### Division formulas in google sheets

Division by using cell reference

=A1/B1

Division of numbers without cell references

=100/4

Division by using the DIVIDE function

=DIVIDE(100/4) ### Square formulas in google sheets

Square by using the cell references

=A2^2

Square numbers without cell references

=3^3

The square numbers using the POWER function

=POWER(3,3) =POW(3,3)

### Square root formulas in google sheets

Square root by the use of cell references

=SQRT(A2)

Square roots numbers without cell references

=SQRT(16) ### The mathematical operations in spreadsheet

Plus sign (+)

Minus sign (-)

Asterisk (*)

Forward slash (/)

Carrot (^)

### The mathematical functions in spreadsheet

=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)

E(Exponents)

M(Multiplication)

D(Division)

S(Subtraction)

### Sample operations

=(6-3)+2^2/4*4-1

=(3)+2^2/4*4-1

=(3)+4/4*4-1

=(3)+4-1

=7-1

=6

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. 