
4. Select column B. Either tap B or use the cursor keys to highlight the B cell.
5. Enter a formula for your commission (being 10% of the price of each item sold):
PRICE 0.1
Because you entered the formula in the heading of a column, it is automatically copied to every cell in
that column. At the moment only 0 is shown, since there are no values in the PRICE column yet.
6. Select column B.
7.
Tap and select Name.
8.
Type COMMIS and tap . The heading of column B is now COMMIS.
9. It is always a good idea to check your formulas by entering some dummy values and noting whether the
result is as expected. Select cell A1 and make sure that
and not is showing in the
menu. (If not, tap the button.) This option means that your cursor automatically selects the cell
immediately following the one you have just entered content into.
10. Add some values in the PRICE column and note the result in the COMMIS column. If the results do not
look right, you can tap the
COMMIS heading, tap , and revise the formula.
212 Chapter 10 Spreadsheet
Komentarze do niniejszej Instrukcji