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

640353