=b1+b2
- Subtraction
=b1-b2
* Multiplication
=b1*b2
/ Division
=b1/b2
Average Function
=average(cell reference)
=average(b2:b22)
Highest
=max(cell reference)
=max(b2:b22)
Lowest
=min(cell reference)
=min(b2:b22)
|
|
|
|
|
|
|
|
|
| Spreadsheet Formulas | ||||||||
| Prinz's Class Home | ||||||||
|
||||||||
| + Addition =b1+b2 - Subtraction =b1-b2 * Multiplication =b1*b2 / Division =b1/b2 Average Function =average(cell reference) =average(b2:b22) Highest =max(cell reference) =max(b2:b22) Lowest =min(cell reference) =min(b2:b22) |
||||||||