Using the formula bar
The cell shows the result, while the real formula inside it is in the formula bar; in this bar a formula can be entered and changed. To the left of the bar are the Name Box (the address of the active cell), then the cancel (✗), enter (✓) and fx buttons. F2 edits inside the cell. In long formulas watch that the brackets match: every bracket that opens must close, or Excel gives a message. “Show Formulas” (Ctrl+`) on the Formulas tab shows formulas in all the cells, and “Evaluate Formula” calculates a complex formula step by step, which helps to find where a mistake is. Advice: write the formula in a cell, not the calculated result – then when a starting number changes, the result updates by itself.
| To the left of the formula bar | Job |
|---|---|
| Name Box | address of the active cell |
| ✗ | cancel |
| ✓ | enter |
| fx | the function wizard |
A class wrote a long formula for a yearly sports kit order and the cell showed an error. A pupil counted the opening and closing brackets and found that one closing bracket was missing. After it was added, the formula calculated correctly.
Accountants, engineers and programmers check long expressions by pairing the brackets, because one missing bracket can spoil the whole result.
On paper write an expression with three pairs of brackets and underline each pair in a different colour to check that every bracket has its partner.
| A | B | C | D | E | F | G | |
|---|---|---|---|---|---|---|---|
| 1 | Bus | Ticket | Students | Lunch | Teachers | Total | |
| 2 | 900 000 | 35 000 | 28 | 40 000 | 2 | 3 080 000 |
“The bracket inspector”: the teacher writes 5 long formulas, some with a missing bracket; students find the mistake in the formula bar and correct it.