I P Basic Math Functions N

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

I P Basic Math Functions N

1269197
Choose:   INTEK home   I   training  I   by Jim Tracy   I