Calculate the Balance

Let's visualize how the equation works. In real words, the balance is whatever you had in the bank, minus any checks you wrote, plus any deposits.

4. Try This: Enter the Equation

Select Cell F3 and type in =. The equals sign is on the top of the keyboard to the right of the row of numbers. All equations begin with =.

Our calculation is =F2-D3+E3.

 

When you hit the Enter or Tab key on your keyboard, Excel will add it all up. Did you get $421.50?

 

Try it again on Cell F4.

The equation would be: =F3-D4+E4.

The answer should be $240.52.

Select Cell F4.

Copy and Paste the formula down to Row 10

What Did You See? Did you notice that the formula changed? Cell F5 now says =F4-D5+E5. This is an example of Relative references.

Exam 77-882: Microsoft Excel 2010 Core

5. Applying Formulas and Functions

5.1. Create formulas: Use Basic Operators-Add, Subtract, Multiple, Divide