Formulas - Creating Manual

In the first example, the focus is to find the difference of the projected budget cost for the month found in cell B9 and the actual total in C9. You can see the formula in the formula bar that was used to write the answer to the problem.

The next example shows how to create a sum of several items, you can see the formula in the Formula bar. Notice the use of the : which tells the formula to sum all the cells including the two listed. The cells must be consecutive to be able to use the “:”. If you wanted to only create a sum for C3,C5 and C6 the formula would be (=SUM(C3;C5;C6). Notice that the semicolon is used instead of the colon.

Notice that the formula does not contain spaces.

The next example is a yearly estimated cost for your Personal Budget. This time use a cell and multiply it by a number, 12 to get a yearly cost. Again, no spaces in the formula.

In this example the purpose is to find the difference for the year, between what the estimated budget was and the actual cost. The parentheses are used to make sure the multiplication occurs before the subtraction.