Ianderson bad by maxwell seed Panderson bad by maxwell seed Basic Math Functions Nanderson bad by maxwell seed

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

Ianderson bad by maxwell seed Panderson bad by maxwell seed Basic Math Functions Nanderson bad by maxwell seed

1160485

Choose:   TRIO homeanderson bad by maxwell seed   I   tutorialsanderson bad by maxwell seed   I   by Brad Jamesanderson bad by maxwell seed   I   bwjames@usd.eduanderson bad by maxwell seed