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.
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 (-)
Forward slash (/)
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
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.