Examples
CHEQUE
BOOK
RECONCILIATION
the value from
the
askn( ) function
in
cell
C3 (another absolute
cell
reference)
by
the
row(
)-3
expression which,
as
we
saw
earlier,
gives a value
of
1
in
row
four,
2
In
row
five,
up
to
12
in
row
fifteen.
We
now need
to
use a
few
commands
to
change the display of the table
to
a more
convenient form. Use the following commands:
JustifY,Cells,Text,Right,Range
b3:b15
JustifY,Cells,Text,Right,Range
d4:d15
Justify,CeLLs,Numbers,Centre,Range
c3
Grid>Width.
5
FROM
b
TO
b
Grid>Width.
3
FROM
c
TO
c
Grid>Width,
2
FROM
d
TO
d
Grid>Width,
4
FROM
e
TO
e
You
use the table
by
forcing a recalculation of the grid with the Xecute command. The
text
of
the
askn( ) function
Will
appear
in
the
Input
line
- and
you
should type
In
a number
between one and
twelve.
This example allows
you
to
keep a check on your bank account.
You
enter
.details
of
your cheques
in
the spaces provided.
At
the end
of
the month
you
add the details of
your
salary,
standing orders
etc.
You
are then provided
With
a balance which you can
compare
With
your bank statements.
The
result,
with a
few
figures added,
is
shown
In
Figure
5.3.
I
A
I
B
C
1
I
CHEQUE
BOOK
RECONC
I
tIATION
2
I
======================
3
I
4
I
Month
Janua ry
5
I
6
I
Opening
baLance
200.00
7
I
Satary
527
.
35
8
I
MisceLLaneous
income
0.00
9
I
10
I
CREDIT
727.35
11
I
12
I
13
I
Standing
orders
130.00
14
I
Charges
0.00
15
I
16
I
Cheques
Date
Cheque
no.
Amount
1
17
I
3/01/84
123456
50.00
..
18
I
10/01/84
123457
50.00
19
I
14/01/84
123458
32.21
20
I
17/01/84
123459
50.00
21
I
24/01/84
123460
50.00
22
I
31/01/84
123461
50.00
23
I
24
I
25
I
26
I
27
I
28
I
DEBIT
412.21
29
I
30
I
Closing
balance
315.14
31
I
Figure
5.3
Cheque
book
reconciliation
[B1]
"CHEQUE
BOOK
RECONCltIATION
[B2]
rept(II=II,
len(b1»
[C4]
"Month
[D4]
askt
("Enter
month")
,
.
12/84
To Next Page
Loading...
