You can create formulas by using numbers (for example, 350+450); however, it is preferable to construct formulas that refer to worksheet cells. This way, the results of the formulas update automatically when you change numbers in your worksheet. In Excel, you create formulas by preceding the expression with an equal sign (=).
For example, enter the number 350 in cell B1; enter the number 450 in B2; enter the formula =B1+B2 in cell B3. The value 800 is displayed in cell B3. Any time that you change the value in cell B1 or B2, Excel recalculates the value of cell B3.
When entering a formula, you can type in cell references or click on the desired cells. Clicking on the cells may eliminate typing errors and prevent mistakes as you determine the cell references by looking at them.
| 12 | 14 | 26 | -2 | 0.857142857 | 168 |
| 54 | 87 | 141 | -33 | 0.620689655 | 4698 |
| 98 | 63 | 161 | 35 | 1.555555556 | 6174 |
| 32 | 15 | 47 | 17 | 2.133333333 | 480 |
| 78 | 28 | 106 | 50 | 2.785714286 | 2184 |
| 274 | 207 | 481 | 67 | 7.952435687 | 13704 |
When you are building formulas, use:
+ for addition
- for subtraction
* for multiplication
/ for division
^ for exponents (for example 3^2 is 3 raised to the 2nd power)
No comments:
Post a Comment