BASIC MICROSOFT EXCEL FUNCTIONS |
|
| Function: | Type this (first, click once in the cell where you want the result to go): |
| Addition | =X1+X2+X3 |
| Subtraction | =X1-X2 |
| Multiplication | =X1*X2 |
| Division | =X1/X2 |
| Sum | =SUM(X1:X14) |
| Sheets | =Sheet1!X2 (place this formula in a cell on a different sheet) |
| Sum using Sheets | =Sheet1!X1+Sheet2!X1+Sheet3!X1 |
| Sum for many Sheets | =Sum('Sheet1:Sheet9'!X1) |
| where X1, X2, X3, etc. are the cells (such as A1, B1, C1, etc.) | |