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**

Table of Contents

**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
**

**=A1+A2
**

**Addition of numbers without cell references
**

** =100+200
**

**Addition by, using the ADD function
**

**=ADD(100,200)
**

**Sum formula in google sheets
**

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

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

**E**(Exponents)

**M**(Multiplication)

**D**(Division)

**A**(Addition)

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

**1 ^{st} 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.

2** ^{nd} 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.