Filter
Top Products
198 Spreadsheet
23.Enter a label for your fixed costs:
S.ANCOSTSE
24.In cell D5, enter 100. This
is what you have to pay
the landowner for renting
the space for your stall.
25.Enter the label PROFIT in
cell C7.
26.In cell D7, enter a formula
to calculate your profit:
S.D3 w D5E
You could also have named D3 and D5—say, TOTCOM and
COSTS respectively. Then the formula in D7 could have
been =TOTCOM–COSTS.
27. Enter the label GOAL in cell E1.
You can swipe the screen with a finger, or repeatedly press
the cursor keys, to bring E1 into view.
28.Enter 250 in cell F1.
This is the minimum profit you want to make on the day.
29. In cell C9, enter the label GO HOME.
30.In cell D9, enter:
S.D7 ≥ F1E
You can select ≥ from the relations palette (Sv).
What this formula does is
place 0 in D9 if you have
not reached your goal
profit, and 1 if you have.
It provides a quick way for
you to see when you have
made enough profit and
can go home.
31. Select C9 and D9.
You can select both cells with a finger drag, or by
highlighting C9, selecting and pressing
>.