/ 8bitfiles.net/archives / archives.tar / archives / commodore-scene-files / Geos / GEOS128 / GeosD81 / cs19.d81 / !h6

< prev

next >

MacOS 8.1

Win98

DOS

view JSON data

view as text

+--------+-------------------------+-------------------------+--------+--------+
|00000000| 00 c8 c1 4e 20 c1 c2 d3 | cf cc d5 d4 c5 20 46 4f |...N ...|..... FO|
|00000010| 52 4d 55 4c 41 20 52 45 | 46 45 52 53 0d 54 4f 20 |RMULA RE|FERS.TO |
|00000020| 53 50 45 43 49 46 49 43 | 2c 20 4e 41 4d 45 44 20 |SPECIFIC|, NAMED |
|00000030| 43 45 4c 4c 53 0d 53 55 | 43 48 20 41 53 20 52 31 |CELLS.SU|CH AS R1|
|00000040| 43 31 20 2b 20 52 32 43 | 31 20 57 48 49 43 48 0d |C1 + R2C|1 WHICH.|
|00000050| 53 55 4d 53 20 54 48 45 | 20 43 4f 4e 54 45 4e 54 |SUMS THE| CONTENT|
|00000060| 53 20 4f 46 20 54 48 4f | 53 45 0d 54 57 4f 20 43 |S OF THO|SE.TWO C|
|00000070| 45 4c 4c 20 4c 4f 43 41 | 54 49 4f 4e 53 2e 0d c2 |ELL LOCA|TIONS...|
|00000080| 45 43 41 55 53 45 20 49 | 54 20 49 53 20 c1 c2 d3 |ECAUSE I|T IS ...|
|00000090| cf cc d5 d4 c5 2c 20 49 | 46 0d 59 4f 55 20 4d 4f |....., I|F.YOU MO|
|000000a0| 56 45 20 54 48 45 20 46 | 4f 52 4d 55 4c 41 20 54 |VE THE F|ORMULA T|
|000000b0| 4f 0d 41 4e 4f 54 48 45 | 52 20 50 4c 41 43 45 20 |O.ANOTHE|R PLACE |
|000000c0| 4f 4e 20 54 48 45 20 53 | 48 45 45 54 0d 49 54 20 |ON THE S|HEET.IT |
|000000d0| 57 49 4c 4c 20 41 4c 57 | 41 59 53 20 52 45 46 45 |WILL ALW|AYS REFE|
|000000e0| 52 20 54 4f 0d 52 31 43 | 31 20 41 4e 44 20 52 32 |R TO.R1C|1 AND R2|
|000000f0| 43 31 2e 0d d3 4f 4d 45 | 20 45 58 41 4d 50 4c 45 |C1...OME| EXAMPLE|
|00000100| 53 20 41 52 45 3a 0d 52 | 39 3a 32 30 43 34 20 28 |S ARE:.R|9:20C4 (|
|00000110| c1 44 44 53 20 41 4c 4c | 20 52 4f 57 53 20 42 45 |.DDS ALL| ROWS BE|
|00000120| 2d 0d 20 20 20 20 20 20 | 20 20 20 54 57 45 45 4e |-.      |   TWEEN|
|00000130| 20 39 20 41 4e 44 20 32 | 30 20 49 4e 0d 20 20 20 | 9 AND 2|0 IN.   |
|00000140| 20 20 20 20 20 20 43 4f | 4c 55 4d 4e 20 34 2e 29 |      CO|LUMN 4.)|
|00000150| 0d 52 32 43 35 2a 52 31 | 43 32 20 28 cd 55 4c 54 |.R2C5*R1|C2 (.ULT|
|00000160| 49 50 4c 49 45 53 20 54 | 48 45 0d 20 20 20 20 20 |IPLIES T|HE.     |
|00000170| 20 20 20 20 20 43 4f 4e | 54 45 4e 54 53 20 4f 46 |     CON|TENTS OF|
|00000180| 20 54 48 45 0d 20 20 20 | 20 20 20 20 20 20 20 54 | THE.   |       T|
|00000190| 57 4f 20 43 45 4c 4c 53 | 2e 0d c1 20 d2 c5 cc c1 |WO CELLS|... ....|
|000001a0| d4 c9 d6 c5 20 46 4f 52 | 4d 55 4c 41 20 52 45 46 |.... FOR|MULA REF|
|000001b0| 45 52 53 20 54 4f 0d 43 | 45 4c 4c 53 20 49 4e 20 |ERS TO.C|ELLS IN |
|000001c0| 52 45 4c 41 54 49 4f 4e | 20 54 4f 20 54 48 45 20 |RELATION| TO THE |
|000001d0| 4c 4f 2d 0d 43 41 54 49 | 4f 4e 20 4f 46 20 54 48 |LO-.CATI|ON OF TH|
|000001e0| 45 20 46 4f 52 4d 55 4c | 41 2e 20 c6 4f 52 0d 45 |E FORMUL|A. .OR.E|
|000001f0| 58 41 4d 50 4c 45 20 52 | 5b 2d 33 5d 43 2b 52 5b |XAMPLE R|[-3]C+R[|
|00000200| 2d 32 5d 43 20 4d 45 41 | 4e 53 0d 41 44 44 20 54 |-2]C MEA|NS.ADD T|
|00000210| 48 45 20 43 4f 4e 54 45 | 4e 54 53 20 4f 46 20 54 |HE CONTE|NTS OF T|
|00000220| 48 45 20 43 45 4c 4c 0d | 54 48 52 45 45 20 d2 cf |HE CELL.|THREE ..|
|00000230| d7 d3 20 41 42 4f 56 45 | 20 54 4f 47 45 54 48 45 |.. ABOVE| TOGETHE|
|00000240| 52 0d 57 49 54 48 20 54 | 48 45 20 43 4f 4e 54 45 |R.WITH T|HE CONTE|
|00000250| 4e 54 53 20 4f 46 20 54 | 48 45 0d 43 45 4c 4c 20 |NTS OF T|HE.CELL |
|00000260| 54 57 4f 20 d2 cf d7 d3 | 20 41 42 4f 56 45 20 54 |TWO ....| ABOVE T|
|00000270| 48 45 0d 50 52 45 53 45 | 4e 54 20 43 45 4c 4c 20 |HE.PRESE|NT CELL |
|00000280| 4c 4f 43 41 54 49 4f 4e | 20 49 4e 20 54 48 45 0d |LOCATION| IN THE.|
|00000290| 53 41 4d 45 20 43 4f 4c | 55 4d 4e 2e 0d c2 45 43 |SAME COL|UMN...EC|
|000002a0| 41 55 53 45 20 49 54 20 | 49 53 20 d2 c5 cc c1 d4 |AUSE IT |IS .....|
|000002b0| c9 d6 c5 2c 20 49 46 0d | 59 4f 55 20 4d 4f 56 45 |..., IF.|YOU MOVE|
|000002c0| 20 54 48 45 20 46 4f 52 | 4d 55 4c 41 20 54 4f 0d | THE FOR|MULA TO.|
|000002d0| 41 4e 4f 54 48 45 52 20 | 50 41 52 54 20 4f 46 20 |ANOTHER |PART OF |
|000002e0| 54 48 45 20 53 48 45 45 | 54 20 49 54 0d 57 49 4c |THE SHEE|T IT.WIL|
|000002f0| 4c 20 52 45 46 45 52 20 | 54 4f 20 54 48 45 20 52 |L REFER |TO THE R|
|00000300| 4f 57 53 20 41 42 4f 56 | 45 0d 54 48 45 20 43 45 |OWS ABOV|E.THE CE|
|00000310| 4c 4c 20 54 48 41 54 20 | 54 48 45 20 46 4f 52 4d |LL THAT |THE FORM|
|00000320| 55 4c 41 20 49 53 0d 4c | 4f 43 41 54 45 44 20 49 |ULA IS.L|OCATED I|
|00000330| 4e 2e 0d d3 4f 4d 45 20 | 45 58 41 4d 50 4c 45 53 |N...OME |EXAMPLES|
|00000340| 20 41 52 45 3a 0d 52 5b | 2d 31 30 5d 3a 5b 2d 31 | ARE:.R[|-10]:[-1|
|00000350| 5d 43 20 28 c1 44 44 20 | 54 48 45 20 52 41 4e 47 |]C (.DD |THE RANG|
|00000360| 45 0d 20 4f 46 20 43 45 | 4c 4c 53 20 46 52 4f 4d |E. OF CE|LLS FROM|
|00000370| 20 54 45 4e 20 52 4f 57 | 53 0d 20 41 42 4f 56 45 | TEN ROW|S. ABOVE|
|00000380| 20 54 4f 20 4f 4e 45 20 | d2 cf d7 20 41 42 4f 56 | TO ONE |... ABOV|
|00000390| 45 20 49 4e 0d 20 54 48 | 45 20 53 41 4d 45 20 43 |E IN. TH|E SAME C|
|000003a0| 4f 4c 55 4d 4e 2e 29 0d | 52 5b 2b 35 5d 43 2d 52 |OLUMN.).|R[+5]C-R|
|000003b0| 5b 2b 36 5d 43 20 20 28 | d2 45 46 45 52 53 20 54 |[+6]C  (|.EFERS T|
|000003c0| 4f 0d 20 54 48 45 20 46 | 49 46 54 48 20 41 4e 44 |O. THE F|IFTH AND|
|000003d0| 20 53 49 58 54 48 20 43 | 45 4c 4c 0d 20 42 45 4c | SIXTH C|ELL. BEL|
|000003e0| 4f 57 20 54 48 45 20 50 | 52 45 53 45 4e 54 20 43 |OW THE P|RESENT C|
|000003f0| 45 4c 4c 2e 29 0d cd c9 | d8 c5 c4 a0 c6 cf d2 cd |ELL.)...|........|
|00000400| d5 cc c1 d3 20 43 41 4e | 20 41 4c 53 4f 20 42 45 |.... CAN| ALSO BE|
|00000410| 0d 55 53 45 44 2e 20 c6 | 4f 52 20 45 58 2e 3a 0d |.USED. .|OR EX.:.|
|00000420| 20 20 20 52 5b 2b 34 5d | 43 2f 52 32 43 32 0d d4 |   R[+4]|C/R2C2..|
|00000430| 48 49 53 20 4d 45 41 4e | 53 2c 20 44 49 56 49 44 |HIS MEAN|S, DIVID|
|00000440| 45 20 54 48 45 20 43 45 | 4c 4c 0d 46 4f 55 52 20 |E THE CE|LL.FOUR |
|00000450| 52 4f 57 53 20 42 45 4c | 4f 57 20 54 48 45 20 50 |ROWS BEL|OW THE P|
|00000460| 52 45 53 45 4e 54 0d 43 | 45 4c 4c 20 42 59 20 52 |RESENT.C|ELL BY R|
|00000470| 32 43 32 2e 0d          |                         |2C2..   |        |
+--------+-------------------------+-------------------------+--------+--------+