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 C1 C2 D3 CF CC D5 D4 C5 A0 52 45 |ive...........RE|
00000020: 46 45 52 45 4E 43 45 53 20 52 45 46 45 52 20 54 |FERENCES REFER T|
00000030: 4F 0D 53 50 45 43 49 46 49 43 20 43 45 4C 4C 20 |O.SPECIFIC CELL |
00000040: 4C 4F 43 41 54 49 4F 4E 53 2E 20 66 4F 52 0D 45 |LOCATIONS. fOR.E|
00000050: 58 41 4D 50 4C 45 2C 20 52 31 43 31 20 52 45 46 |XAMPLE, R1C1 REF|
00000060: 45 52 53 20 54 4F 20 54 48 45 20 43 45 4C 4C 0D |ERS TO THE CELL.|
00000070: 49 4E 20 54 48 45 20 55 50 50 45 52 20 4C 45 46 |IN THE UPPER LEF|
00000080: 54 20 43 4F 52 4E 45 52 20 4F 46 20 54 48 45 0D |T CORNER OF THE.|
00000090: 53 48 45 45 54 2C 20 41 4E 44 20 52 31 3A 32 43 |SHEET, AND R1:2C|
000000A0: 31 20 49 53 20 54 48 45 20 53 55 4D 20 4F 46 20 |1 IS THE SUM OF |
000000B0: 0D 54 48 45 20 46 49 52 53 54 20 54 57 4F 20 43 |.THE FIRST TWO C|
000000C0: 45 4C 4C 53 20 49 4E 20 43 4F 4C 55 4D 4E 20 31 |ELLS IN COLUMN 1|
000000D0: 2C 0D 52 45 47 41 52 44 4C 45 53 53 20 4F 46 20 |,.REGARDLESS OF |
000000E0: 57 48 45 52 45 20 54 48 45 20 50 4F 49 4E 54 45 |WHERE THE POINTE|
000000F0: 52 0D 49 53 2E 0D 0D 72 65 6C 61 74 69 76 65 20 |R.IS...relative |
00000100: 46 4F 52 4D 55 4C 41 53 20 52 45 46 45 52 20 54 |FORMULAS REFER T|
00000110: 4F 20 0D 4C 4F 43 41 54 49 4F 4E 53 20 54 48 41 |O .LOCATIONS THA|
00000120: 54 20 44 45 50 45 4E 44 20 4F 4E 20 57 48 45 52 |T DEPEND ON WHER|
00000130: 45 0D 54 48 45 20 43 45 4C 4C 20 50 4F 49 4E 54 |E.THE CELL POINT|
00000140: 45 52 20 49 53 20 57 48 45 4E 20 59 4F 55 0D 45 |ER IS WHEN YOU.E|
00000150: 4E 54 45 52 20 54 48 45 20 52 45 46 45 52 45 4E |NTER THE REFEREN|
00000160: 43 45 2E 20 66 4F 52 0D 45 58 41 4D 50 4C 45 2C |CE. fOR.EXAMPLE,|
00000170: 20 52 5B 2D 32 5D 43 2B 52 5B 2D 31 7D 43 20 4D | R[-2]C+R[-1}C M|
00000180: 45 41 4E 53 20 41 44 44 0D 54 48 45 20 54 57 4F |EANS ADD.THE TWO|
00000190: 20 43 45 4C 4C 53 20 41 42 4F 56 45 20 54 48 49 | CELLS ABOVE THI|
000001A0: 53 20 4F 4E 45 2E 0D 77 48 49 43 48 20 54 57 4F |S ONE..wHICH TWO|
000001B0: 20 43 45 4C 4C 53 20 54 48 45 53 45 20 41 52 45 | CELLS THESE ARE|
000001C0: 0D 44 45 50 45 4E 44 53 20 4F 4E 20 54 48 45 20 |.DEPENDS ON THE |
000001D0: 4C 4F 43 41 54 49 4F 4E 20 4F 46 20 54 48 45 20 |LOCATION OF THE |
000001E0: 0D 43 45 4C 4C 20 50 4F 49 4E 54 45 52 20 57 48 |.CELL POINTER WH|
000001F0: 45 4E 20 59 4F 55 20 50 52 45 53 53 0D 72 65 74 |EN YOU PRESS.ret|
00000200: 75 72 6E 2E 0D 0D 61 62 73 6F 6C 75 74 65 20 52 |urn...absolute R|
00000210: 45 46 45 52 45 4E 43 45 53 20 41 52 45 20 42 45 |EFERENCES ARE BE|
00000220: 54 54 45 52 0D 49 46 20 59 4F 55 20 45 58 50 45 |TTER.IF YOU EXPE|
00000230: 43 54 20 59 4F 55 20 57 49 4C 4C 20 4E 45 45 44 |CT YOU WILL NEED|
00000240: 20 54 4F 0D 4D 4F 56 45 20 46 4F 52 4D 55 4C 41 | TO.MOVE FORMULA|
00000250: 53 20 57 49 54 48 4F 55 54 20 4D 4F 56 49 4E 47 |S WITHOUT MOVING|
00000260: 20 54 48 45 0D 43 45 4C 4C 53 20 54 4F 20 57 48 | THE.CELLS TO WH|
00000270: 49 43 48 20 54 48 45 59 20 52 45 46 45 52 2E 0D |ICH THEY REFER..|
00000280: 0D 79 4F 55 20 43 41 4E 20 41 4C 53 4F 20 55 53 |.yOU CAN ALSO US|
00000290: 45 20 6D 69 78 65 64 20 41 42 53 4F 4C 55 54 45 |E mixed ABSOLUTE|
000002A0: 0D 41 4E 44 20 52 45 4C 41 54 49 56 45 20 52 45 |.AND RELATIVE RE|
000002B0: 46 45 52 45 4E 43 45 53 2E 20 66 4F 52 0D 45 58 |FERENCES. fOR.EX|
000002C0: 41 4D 50 4C 45 2C 20 52 32 3A 5B 2D 31 5D 43 20 |AMPLE, R2:[-1]C |
000002D0: 52 45 46 45 52 53 20 54 4F 20 41 4C 4C 20 0D 54 |REFERS TO ALL .T|
000002E0: 48 45 20 43 45 4C 4C 53 20 49 4E 20 54 48 45 20 |HE CELLS IN THE |
000002F0: 43 55 52 52 45 4E 54 20 43 4F 4C 55 4D 4E 0D 46 |CURRENT COLUMN.F|
00000300: 52 4F 4D 20 52 4F 57 20 32 20 54 4F 20 54 48 45 |ROM ROW 2 TO THE|
00000310: 20 52 4F 57 20 41 42 4F 56 45 20 54 48 45 0D 43 | ROW ABOVE THE.C|
00000320: 55 52 52 45 4E 54 20 43 45 4C 4C 3B 20 59 4F 55 |URRENT CELL; YOU|
00000330: 20 43 4F 55 4C 44 20 55 53 45 20 54 48 49 53 0D | COULD USE THIS.|
00000340: 54 4F 20 54 4F 54 41 4C 20 41 20 43 4F 4C 55 4D |TO TOTAL A COLUM|
00000350: 4E 20 4F 46 20 4E 55 4D 42 45 52 53 2E 0D |N OF NUMBERS.. |
ABSOLUTE & RELATIVE..ABSOLUTE REFERENCES
REFER TO.SPECIFIC CELL LOCATIONS. FOR.E
XAMPLE, R1C1 REFERS TO THE CELL.IN THE U
PPER LEFT CORNER OF THE.SHEET, AND R1:2C
1 IS THE SUM OF .THE FIRST TWO CELLS IN
COLUMN 1,.REGARDLESS OF WHERE THE POINTE
R.IS...RELATIVE FORMULAS REFER TO .LOCAT
IONS THAT DEPEND ON WHERE.THE CELL POINT
ER IS WHEN YOU.ENTER THE REFERENCE. FOR.
EXAMPLE, R[-2]C+R[-1}C MEANS ADD.THE TWO
CELLS ABOVE THIS ONE..WHICH TWO CELLS T
HESE ARE.DEPENDS ON THE LOCATION OF THE
.CELL POINTER WHEN YOU PRESS.RETURN...AB
SOLUTE REFERENCES ARE BETTER.IF YOU EXPE
CT YOU WILL NEED TO.MOVE FORMULAS WITHOU
T MOVING THE.CELLS TO WHICH THEY REFER..
.YOU CAN ALSO USE MIXED ABSOLUTE.AND REL
ATIVE REFERENCES. FOR.EXAMPLE, R2:[-1]C
REFERS TO ALL .THE CELLS IN THE CURRENT
COLUMN.FROM ROW 2 TO THE ROW ABOVE THE.C
URRENT CELL; YOU COULD USE THIS.TO TOTAL
A COLUMN OF NUMBERS..
×
C64 Image
> CLICK IMAGE PREVIEW FOR FULL MODAL