Basic Math Functions

Spreadsheets have many Math functions built into them. Of the most basic operations are the standard multiply, divide, add and subtract. These operations follow the order of operations (just like algebra). Let's look at some examples.

---

For these following examples let's consider the following data:

A1 (column A, row 1) = 5 A2 (column A, row 2) = 7 A3 (column A, row 3) = 8 B1 (column B, row 1) = 3 B2 (column B, row 2) = 4 B3 (column B, row 3) = 6

A B 1 5 3 2 7 4 3 8 6

---

Operation	Symbol	Constant Data	Referenced Data	Answer
Multiplication	*	= 5 * 6	= A1 * B3	30
Division	/	= 8 / 4	= A3 / B2	2
Addition	+	= 4 + 7	= B2 + A2	11
Subtraction	-	= 8 - 3	= A3 - B1	5