00000000: 61 62 73 6F 6C 75 74 65 20 26 20 72 65 6C 61 74 |absolute & relat|
00000010: 69 76 65 0D 0D 61 62 73 6F 6C 75 74 65 20 52 45 |ive..absolute RE|
00000020: 46 45 52 45 4E 43 45 53 20 52 45 4C 41 54 45 20 |FERENCES RELATE |
00000030: 54 4F 0D 53 50 45 43 49 46 49 43 20 43 45 4C 4C |TO.SPECIFIC CELL|
00000040: 20 4C 4F 43 41 54 49 4F 4E 53 2E 20 66 4F 52 0D | LOCATIONS. fOR.|
00000050: 45 58 41 4D 50 4C 45 2C 20 52 31 43 32 20 52 45 |EXAMPLE, R1C2 RE|
00000060: 46 45 52 53 20 54 4F 20 54 48 45 20 43 45 4C 4C |FERS TO THE CELL|
00000070: 0D 49 4E 20 72 4F 57 20 31 2C 20 63 4F 4C 55 4D |.IN rOW 1, cOLUM|
00000080: 4E 20 32 3B 20 52 31 3A 35 43 31 3A 31 30 0D 52 |N 2; R1:5C1:10.R|
00000090: 45 46 45 52 53 20 54 4F 20 54 48 45 20 42 4C 4F |EFERS TO THE BLO|
000000A0: 43 4B 20 4F 46 20 52 4F 57 53 20 31 0D 54 4F 20 |CK OF ROWS 1.TO |
000000B0: 35 20 41 4E 44 20 43 4F 4C 55 4D 4E 53 20 31 20 |5 AND COLUMNS 1 |
000000C0: 54 4F 20 31 30 2E 0D 0D 72 65 6C 61 74 69 76 65 |TO 10...relative|
000000D0: 20 52 45 46 45 52 45 4E 43 45 53 20 52 45 4C 41 | REFERENCES RELA|
000000E0: 54 45 20 54 4F 0D 43 45 4C 4C 53 20 54 48 41 54 |TE TO.CELLS THAT|
000000F0: 20 48 41 56 45 20 41 20 50 41 52 54 49 43 55 4C | HAVE A PARTICUL|
00000100: 41 52 0D 52 45 4C 41 54 49 4F 4E 20 54 4F 20 54 |AR.RELATION TO T|
00000110: 48 45 20 43 45 4C 4C 20 50 4F 49 4E 54 45 52 2E |HE CELL POINTER.|
00000120: 0D 52 5B 2D 32 5D 43 5B 2D 31 5D 2C 20 46 4F 52 |.R[-2]C[-1], FOR|
00000130: 20 45 58 41 4D 50 4C 45 2C 20 52 45 46 45 52 53 | EXAMPLE, REFERS|
00000140: 0D 54 4F 20 54 48 45 20 43 45 4C 4C 20 54 57 4F |.TO THE CELL TWO|
00000150: 20 52 4F 57 53 20 55 50 20 41 4E 44 20 4F 4E 45 | ROWS UP AND ONE|
00000160: 0D 43 4F 4C 55 4D 4E 20 54 4F 20 54 48 45 20 4C |.COLUMN TO THE L|
00000170: 45 46 54 20 4F 46 20 54 48 45 20 43 45 4C 4C 0D |EFT OF THE CELL.|
00000180: 50 4F 49 4E 54 45 52 2E 0D 0D 79 4F 55 20 57 49 |POINTER...yOU WI|
00000190: 4C 4C 20 55 53 55 41 4C 4C 59 20 55 53 45 20 C1 |LL USUALLY USE .|
000001A0: 62 73 6F 6C 75 74 65 0D 52 45 46 45 52 45 4E 43 |bsolute.REFERENC|
000001B0: 45 53 20 57 49 54 48 20 74 72 69 6F 20 66 69 6C |ES WITH trio fil|
000001C0: 65 20 53 49 4E 43 45 0D 59 4F 55 27 4C 4C 20 47 |e SINCE.YOU'LL G|
000001D0: 45 4E 45 52 41 4C 4C 59 20 42 45 20 52 45 46 45 |ENERALLY BE REFE|
000001E0: 52 52 49 4E 47 20 54 4F 0D 50 41 52 54 49 43 55 |RRING TO.PARTICU|
000001F0: 4C 41 52 20 52 45 43 4F 52 44 53 2E 20 79 4F 55 |LAR RECORDS. yOU|
00000200: 20 43 41 4E 2C 0D 48 4F 57 45 56 45 52 2C 20 55 | CAN,.HOWEVER, U|
00000210: 53 45 20 41 20 72 65 6C 61 74 69 76 65 0D 52 45 |SE A relative.RE|
00000220: 46 45 52 45 4E 43 45 20 54 4F 20 4D 45 41 53 55 |FERENCE TO MEASU|
00000230: 52 45 20 46 52 4F 4D 20 54 48 45 0D 43 55 52 52 |RE FROM THE.CURR|
00000240: 45 4E 54 20 43 45 4C 4C 20 50 4F 49 4E 54 45 52 |ENT CELL POINTER|
00000250: 2E 20 20 74 48 45 20 4D 4F 53 54 0D 43 4F 4D 4D |. tHE MOST.COMM|
00000260: 4F 4E 20 49 4E 53 54 41 4E 43 45 20 4F 46 20 54 |ON INSTANCE OF T|
00000270: 48 49 53 2C 20 49 53 20 54 4F 0D 55 53 45 20 43 |HIS, IS TO.USE C|
00000280: 45 4C 4C 20 52 45 46 45 52 45 4E 43 45 20 22 52 |ELL REFERENCE "R|
00000290: 43 22 20 54 4F 0D 44 45 53 49 47 4E 41 54 45 20 |C" TO.DESIGNATE |
000002A0: 22 54 48 49 53 20 43 45 4C 4C 22 20 28 54 48 45 |"THIS CELL" (THE|
000002B0: 20 4F 4E 45 0D 49 4E 20 57 48 49 43 48 20 54 48 | ONE.IN WHICH TH|
000002C0: 45 20 43 45 4C 4C 20 50 4F 49 4E 54 45 52 20 53 |E CELL POINTER S|
000002D0: 49 54 53 29 2E 0D D4 48 49 53 20 49 53 20 55 53 |ITS)...HIS IS US|
000002E0: 45 46 55 4C 20 49 4E 20 C2 4C 41 4E 4B 20 41 4E |EFUL IN .LANK AN|
000002F0: 44 0D C3 4F 50 59 2E 20 20 D4 48 55 53 2C 20 59 |D..OPY. .HUS, Y|
00000300: 4F 55 20 43 41 4E 20 42 4C 41 4E 4B 20 54 48 45 |OU CAN BLANK THE|
00000310: 0D 43 55 52 52 45 4E 54 20 52 4F 57 20 41 4E 44 |.CURRENT ROW AND|
00000320: 20 54 48 45 20 4E 45 58 54 20 35 20 52 4F 57 53 | THE NEXT 5 ROWS|
00000330: 0D 44 4F 57 4E 20 42 59 20 45 4E 54 45 52 49 4E |.DOWN BY ENTERIN|
00000340: 47 20 52 3A 5B 2B 35 5D 43 31 3A 31 30 20 41 54 |G R:[+5]C1:10 AT|
00000350: 0D 54 48 45 20 27 C2 4C 41 4E 4B 27 20 50 52 4F |.THE '.LANK' PRO|
00000360: 4D 50 54 2E 0D |MPT.. |
ABSOLUTE & RELATIVE..ABSOLUTE REFERENCES
RELATE TO.SPECIFIC CELL LOCATIONS. FOR.
EXAMPLE, R1C2 REFERS TO THE CELL.IN ROW
1, COLUMN 2; R1:5C1:10.REFERS TO THE BLO
CK OF ROWS 1.TO 5 AND COLUMNS 1 TO 10...
RELATIVE REFERENCES RELATE TO.CELLS THAT
HAVE A PARTICULAR.RELATION TO THE CELL
POINTER..R[-2]C[-1], FOR EXAMPLE, REFERS
.TO THE CELL TWO ROWS UP AND ONE.COLUMN
TO THE LEFT OF THE CELL.POINTER...YOU WI
LL USUALLY USE ABSOLUTE.REFERENCES WITH
TRIO FILE SINCE.YOU'LL GENERALLY BE REFE
RRING TO.PARTICULAR RECORDS. YOU CAN,.HO
WEVER, USE A RELATIVE.REFERENCE TO MEASU
RE FROM THE.CURRENT CELL POINTER. THE M
OST.COMMON INSTANCE OF THIS, IS TO.USE C
ELL REFERENCE "RC" TO.DESIGNATE "THIS CE
LL" (THE ONE.IN WHICH THE CELL POINTER S
ITS)..THIS IS USEFUL IN BLANK AND.COPY.
THUS, YOU CAN BLANK THE.CURRENT ROW AND
THE NEXT 5 ROWS.DOWN BY ENTERING R:[+5]
C1:10 AT.THE 'BLANK' PROMPT..
×
C64 Image
> CLICK IMAGE PREVIEW FOR FULL MODAL