home *** CD-ROM | disk | FTP | other *** search
| Unknown | 1997-06-18 | 69.9 KB |
open in: 
MacOS 8.1
|
Win98
|
DOS
view JSON data
|
view as text
This file was not able to be converted.
This format is not currently supported by dexvert.
| Confidence | Program | Detection | Match Type | Support
|
|---|
| 100%
| file
| data
| default
|
|
hex view+--------+-------------------------+-------------------------+--------+--------+
|00000000| c4 05 00 00 a7 06 00 00 | 5d 08 00 00 21 09 00 00 |........|]...!...|
|00000010| 03 0a 00 00 ab 0a 00 00 | 80 0b 00 00 47 0c 00 00 |........|....G...|
|00000020| 0c 0d 00 00 c1 0d 00 00 | 81 0e 00 00 b6 0e 00 00 |........|........|
|00000030| fc 0f 00 00 e5 10 00 00 | 00 12 00 00 8f 13 00 00 |........|........|
|00000040| 07 14 00 00 65 14 00 00 | e3 14 00 00 5b 15 00 00 |....e...|....[...|
|00000050| 9e 15 00 00 fa 15 00 00 | a4 16 00 00 1c 17 00 00 |........|........|
|00000060| 94 17 00 00 18 18 00 00 | 85 18 00 00 18 19 00 00 |........|........|
|00000070| fe 19 00 00 b4 1c 00 00 | eb 1f 00 00 cb 20 00 00 |........|..... ..|
|00000080| 16 22 00 00 95 22 00 00 | 41 23 00 00 62 23 00 00 |."..."..|A#..b#..|
|00000090| 84 23 00 00 69 24 00 00 | 1e 25 00 00 cc 25 00 00 |.#..i$..|.%...%..|
|000000a0| a2 26 00 00 9f 28 00 00 | 89 2a 00 00 82 2c 00 00 |.&...(..|.*...,..|
|000000b0| 77 2e 00 00 6c 30 00 00 | 40 32 00 00 f3 32 00 00 |w...l0..|@2...2..|
|000000c0| b9 34 00 00 e5 35 00 00 | 18 38 00 00 53 3a 00 00 |.4...5..|.8..S:..|
|000000d0| 7f 3c 00 00 dc 3e 00 00 | e8 3e 00 00 f7 3e 00 00 |.<...>..|.>...>..|
|000000e0| ff 3e 00 00 ef 40 00 00 | 12 43 00 00 47 45 00 00 |.>...@..|.C..GE..|
|000000f0| 45 47 00 00 b9 49 00 00 | 89 4b 00 00 a2 4c 00 00 |EG...I..|.K...L..|
|00000100| 16 4d 00 00 fe 4e 00 00 | 4c 50 00 00 88 51 00 00 |.M...N..|LP...Q..|
|00000110| 6c 52 00 00 4c 53 00 00 | 32 54 00 00 91 55 00 00 |lR..LS..|2T...U..|
|00000120| 78 56 00 00 47 57 00 00 | 1e 58 00 00 85 58 00 00 |xV..GW..|.X...X..|
|00000130| 40 59 00 00 e3 59 00 00 | 8c 5a 00 00 25 5d 00 00 |@Y...Y..|.Z..%]..|
|00000140| 3a 5d 00 00 51 5d 00 00 | 8d 5d 00 00 65 5f 00 00 |:]..Q]..|.]..e_..|
|00000150| 08 60 00 00 23 60 00 00 | 25 60 00 00 c7 60 00 00 |.`..#`..|%`...`..|
|00000160| d1 60 00 00 e3 60 00 00 | e5 60 00 00 f1 60 00 00 |.`...`..|.`...`..|
|00000170| 07 61 00 00 09 61 00 00 | 1f 61 00 00 21 61 00 00 |.a...a..|.a..!a..|
|00000180| 23 61 00 00 2e 61 00 00 | ea 61 00 00 75 62 00 00 |#a...a..|.a..ub..|
|00000190| 31 63 00 00 a3 64 00 00 | 4f 67 00 00 46 6a 00 00 |1c...d..|Og..Fj..|
|000001a0| 5f 6a 00 00 9f 6a 00 00 | 44 6b 00 00 50 6b 00 00 |_j...j..|Dk..Pk..|
|000001b0| 66 6b 00 00 79 6b 00 00 | 2a 6c 00 00 44 6c 00 00 |fk..yk..|*l..Dl..|
|000001c0| eb 6c 00 00 95 6d 00 00 | 0a 6e 00 00 03 6f 00 00 |.l...m..|.n...o..|
|000001d0| e3 6f 00 00 c1 70 00 00 | 6c 71 00 00 ef 71 00 00 |.o...p..|lq...q..|
|000001e0| 52 73 00 00 35 75 00 00 | e7 75 00 00 0b 76 00 00 |Rs..5u..|.u...v..|
|000001f0| 17 76 00 00 04 78 00 00 | 44 79 00 00 0f 7a 00 00 |.v...x..|Dy...z..|
|00000200| ad 7a 00 00 4f 7b 00 00 | c4 7b 00 00 73 7c 00 00 |.z..O{..|.{..s|..|
|00000210| 22 7d 00 00 39 7d 00 00 | 44 7d 00 00 4f 7d 00 00 |"}..9}..|D}..O}..|
|00000220| 5a 7d 00 00 6f 7d 00 00 | 7f 7d 00 00 8f 7d 00 00 |Z}..o}..|.}...}..|
|00000230| a7 7d 00 00 a1 7e 00 00 | 80 7f 00 00 a3 80 00 00 |.}...~..|........|
|00000240| 0b 82 00 00 65 84 00 00 | 87 84 00 00 96 84 00 00 |....e...|........|
|00000250| a0 84 00 00 e3 85 00 00 | 6f 86 00 00 e1 88 00 00 |........|o.......|
|00000260| eb 88 00 00 12 89 00 00 | 41 89 00 00 6a 89 00 00 |........|A...j...|
|00000270| 90 89 00 00 ba 89 00 00 | c4 89 00 00 db 89 00 00 |........|........|
|00000280| fd 89 00 00 1f 8a 00 00 | 2c 8a 00 00 b4 8a 00 00 |........|,.......|
|00000290| 4d 8b 00 00 f8 8b 00 00 | de 8c 00 00 ef 8c 00 00 |M.......|........|
|000002a0| 88 8f 00 00 ca 91 00 00 | a9 92 00 00 bc 92 00 00 |........|........|
|000002b0| e6 92 00 00 f5 92 00 00 | f7 92 00 00 f9 92 00 00 |........|........|
|000002c0| 0f 93 00 00 27 93 00 00 | 48 93 00 00 63 93 00 00 |....'...|H...c...|
|000002d0| 71 93 00 00 7d 93 00 00 | 88 93 00 00 aa 93 00 00 |q...}...|........|
|000002e0| 68 94 00 00 e3 94 00 00 | f8 94 00 00 03 95 00 00 |h.......|........|
|000002f0| 1a 95 00 00 2f 95 00 00 | 1e 97 00 00 c5 97 00 00 |..../...|........|
|00000300| e5 97 00 00 0e 98 00 00 | fe 98 00 00 b7 99 00 00 |........|........|
|00000310| 97 9b 00 00 69 9d 00 00 | 48 9e 00 00 07 9f 00 00 |....i...|H.......|
|00000320| f6 a0 00 00 00 a1 00 00 | 1a a1 00 00 1a a1 00 00 |........|........|
|00000330| 1a a1 00 00 1c a1 00 00 | 1e a1 00 00 20 a1 00 00 |........|.... ...|
|00000340| 22 a1 00 00 24 a1 00 00 | 26 a1 00 00 28 a1 00 00 |"...$...|&...(...|
|00000350| 2a a1 00 00 1b a2 00 00 | 0d a3 00 00 0f a3 00 00 |*.......|........|
|00000360| 11 a3 00 00 81 a4 00 00 | 81 a4 00 00 81 a4 00 00 |........|........|
|00000370| d1 a6 00 00 8f a8 00 00 | 33 a9 00 00 81 ac 00 00 |........|3.......|
|00000380| 83 ac 00 00 92 ac 00 00 | 94 ac 00 00 b4 ac 00 00 |........|........|
|00000390| 7d ad 00 00 78 ae 00 00 | bc ae 00 00 02 af 00 00 |}...x...|........|
|000003a0| 69 af 00 00 d0 af 00 00 | 39 b0 00 00 ac b0 00 00 |i.......|9.......|
|000003b0| 7f b2 00 00 81 b3 00 00 | 8b b3 00 00 8d b3 00 00 |........|........|
|000003c0| a4 b3 00 00 c9 b3 00 00 | fd b3 00 00 29 b4 00 00 |........|....)...|
|000003d0| 57 b4 00 00 ff b4 00 00 | 01 b5 00 00 3a b5 00 00 |W.......|....:...|
|000003e0| 4b b7 00 00 55 b7 00 00 | 55 b7 00 00 55 b7 00 00 |K...U...|U...U...|
|000003f0| 60 b7 00 00 dc b8 00 00 | f0 b8 00 00 fb b8 00 00 |`.......|........|
|00000400| fd b8 00 00 06 b9 00 00 | 15 b9 00 00 27 b9 00 00 |........|....'...|
|00000410| 42 b9 00 00 6a b9 00 00 | 8a ba 00 00 91 ba 00 00 |B...j...|........|
|00000420| 98 ba 00 00 aa ba 00 00 | c3 ba 00 00 da ba 00 00 |........|........|
|00000430| b4 bc 00 00 c9 bc 00 00 | cc bd 00 00 59 bf 00 00 |........|....Y...|
|00000440| f9 bf 00 00 a2 c1 00 00 | f5 c2 00 00 ed c3 00 00 |........|........|
|00000450| 0d c5 00 00 cb c5 00 00 | 2e c7 00 00 70 c8 00 00 |........|....p...|
|00000460| ec c8 00 00 2a ca 00 00 | 84 cb 00 00 19 cd 00 00 |....*...|........|
|00000470| c1 cd 00 00 8c ce 00 00 | 89 cf 00 00 61 d1 00 00 |........|....a...|
|00000480| ff d2 00 00 b5 d3 00 00 | 95 d4 00 00 b6 d5 00 00 |........|........|
|00000490| 18 d7 00 00 60 d8 00 00 | ec d9 00 00 8a da 00 00 |....`...|........|
|000004a0| dc db 00 00 c0 dc 00 00 | c3 dd 00 00 10 de 00 00 |........|........|
|000004b0| e0 de 00 00 d9 df 00 00 | 1b e1 00 00 9c e2 00 00 |........|........|
|000004c0| 2f e4 00 00 c9 e5 00 00 | 56 e7 00 00 bb e8 00 00 |/.......|V.......|
|000004d0| e2 e9 00 00 23 eb 00 00 | 73 ec 00 00 0a ee 00 00 |....#...|s.......|
|000004e0| 9f ef 00 00 49 f0 00 00 | 9e f1 00 00 f1 f2 00 00 |....I...|........|
|000004f0| 46 f4 00 00 aa f5 00 00 | b0 f7 00 00 71 f8 00 00 |F.......|....q...|
|00000500| 35 f9 00 00 2b fa 00 00 | 31 fb 00 00 f3 fb 00 00 |5...+...|1.......|
|00000510| ea fc 00 00 d0 fd 00 00 | b1 fe 00 00 99 ff 00 00 |........|........|
|00000520| 85 00 01 00 3c 01 01 00 | a3 02 01 00 78 03 01 00 |....<...|....x...|
|00000530| 58 04 01 00 78 05 01 00 | 78 05 01 00 a2 05 01 00 |X...x...|x.......|
|00000540| c6 05 01 00 83 06 01 00 | 1b 07 01 00 7b 07 01 00 |........|....{...|
|00000550| 97 07 01 00 c4 07 01 00 | 01 08 01 00 55 08 01 00 |........|....U...|
|00000560| aa 08 01 00 a5 09 01 00 | d9 0a 01 00 db 0b 01 00 |........|........|
|00000570| 4e 0c 01 00 63 0c 01 00 | a2 0c 01 00 a4 0c 01 00 |N...c...|........|
|00000580| a6 0c 01 00 a8 0c 01 00 | aa 0c 01 00 83 0d 01 00 |........|........|
|00000590| b0 0d 01 00 eb 0d 01 00 | 00 0e 01 00 2a 0f 01 00 |........|....*...|
|000005a0| 99 10 01 00 9b 10 01 00 | 95 11 01 00 60 12 01 00 |........|....`...|
|000005b0| 2c 13 01 00 6f 14 01 00 | 6e 15 01 00 9f 16 01 00 |,...o...|n.......|
|000005c0| 9c 17 01 00 11 76 61 6c | 75 65 31 2c 76 61 6c 75 |.....val|ue1,valu|
|000005d0| 65 32 2c 2e 2e 2e 00 58 | 43 6f 75 6e 74 73 20 74 |e2,....X|Counts t|
|000005e0| 68 65 20 6e 75 6d 62 65 | 72 20 6f 66 20 63 65 6c |he numbe|r of cel|
|000005f0| 6c 73 20 74 68 61 74 20 | 63 6f 6e 74 61 69 6e 20 |ls that |contain |
|00000600| 6e 75 6d 62 65 72 73 20 | 61 6e 64 20 6e 75 6d 62 |numbers |and numb|
|00000610| 65 72 73 20 77 69 74 68 | 69 6e 20 74 68 65 20 6c |ers with|in the l|
|00000620| 69 73 74 20 6f 66 20 61 | 72 67 75 6d 65 6e 74 73 |ist of a|rguments|
|00000630| 75 61 72 65 20 31 20 74 | 6f 20 33 30 20 61 72 67 |uare 1 t|o 30 arg|
|00000640| 75 6d 65 6e 74 73 20 74 | 68 61 74 20 63 61 6e 20 |uments t|hat can |
|00000650| 63 6f 6e 74 61 69 6e 20 | 6f 72 20 72 65 66 65 72 |contain |or refer|
|00000660| 20 74 6f 20 61 20 76 61 | 72 69 65 74 79 20 6f 66 | to a va|riety of|
|00000670| 20 64 69 66 66 65 72 65 | 6e 74 20 74 79 70 65 73 | differe|nt types|
|00000680| 20 6f 66 20 64 61 74 61 | 2c 20 62 75 74 20 6f 6e | of data|, but on|
|00000690| 6c 79 20 6e 75 6d 62 65 | 72 73 20 61 72 65 20 63 |ly numbe|rs are c|
|000006a0| 6f 75 6e 74 65 64 00 29 | 6c 6f 67 69 63 61 6c 5f |ounted.)|logical_|
|000006b0| 74 65 73 74 2c 76 61 6c | 75 65 5f 69 66 5f 74 72 |test,val|ue_if_tr|
|000006c0| 75 65 2c 76 61 6c 75 65 | 5f 69 66 5f 66 61 6c 73 |ue,value|_if_fals|
|000006d0| 65 0c 6c 6f 67 69 63 61 | 6c 5f 74 65 73 74 00 69 |e.logica|l_test.i|
|000006e0| 52 65 74 75 72 6e 73 20 | 6f 6e 65 20 76 61 6c 75 |Returns |one valu|
|000006f0| 65 20 69 66 20 61 20 63 | 6f 6e 64 69 74 69 6f 6e |e if a c|ondition|
|00000700| 20 79 6f 75 20 73 70 65 | 63 69 66 79 20 65 76 61 | you spe|cify eva|
|00000710| 6c 75 61 74 65 73 20 74 | 6f 20 54 52 55 45 20 61 |luates t|o TRUE a|
|00000720| 6e 64 20 61 6e 6f 74 68 | 65 72 20 76 61 6c 75 65 |nd anoth|er value|
|00000730| 20 69 66 20 69 74 20 65 | 76 61 6c 75 61 74 65 73 | if it e|valuates|
|00000740| 20 74 6f 20 46 41 4c 53 | 45 41 69 73 20 61 6e 79 | to FALS|EAis any|
|00000750| 20 76 61 6c 75 65 20 6f | 72 20 65 78 70 72 65 73 | value o|r expres|
|00000760| 73 69 6f 6e 20 74 68 61 | 74 20 63 61 6e 20 62 65 |sion tha|t can be|
|00000770| 20 65 76 61 6c 75 61 74 | 65 64 20 74 6f 20 54 52 | evaluat|ed to TR|
|00000780| 55 45 20 6f 72 20 46 41 | 4c 53 45 7a 69 73 20 74 |UE or FA|LSEzis t|
|00000790| 68 65 20 76 61 6c 75 65 | 20 74 68 61 74 20 69 73 |he value| that is|
|000007a0| 20 72 65 74 75 72 6e 65 | 64 20 69 66 20 4c 6f 67 | returne|d if Log|
|000007b0| 69 63 61 6c 5f 74 65 73 | 74 20 69 73 20 54 52 55 |ical_tes|t is TRU|
|000007c0| 45 2e 20 49 66 20 6f 6d | 69 74 74 65 64 2c 20 54 |E. If om|itted, T|
|000007d0| 52 55 45 20 69 73 20 72 | 65 74 75 72 6e 65 64 2e |RUE is r|eturned.|
|000007e0| 20 59 6f 75 20 63 61 6e | 20 6e 65 73 74 20 75 70 | You can| nest up|
|000007f0| 20 74 6f 20 73 65 76 65 | 6e 20 49 46 20 66 75 6e | to seve|n IF fun|
|00000800| 63 74 69 6f 6e 73 55 69 | 73 20 74 68 65 20 76 61 |ctionsUi|s the va|
|00000810| 6c 75 65 20 74 68 61 74 | 20 69 73 20 72 65 74 75 |lue that| is retu|
|00000820| 72 6e 65 64 20 69 66 20 | 4c 6f 67 69 63 61 6c 5f |rned if |Logical_|
|00000830| 74 65 73 74 20 69 73 20 | 46 41 4c 53 45 2e 20 49 |test is |FALSE. I|
|00000840| 66 20 6f 6d 69 74 74 65 | 64 2c 20 46 41 4c 53 45 |f omitte|d, FALSE|
|00000850| 20 69 73 20 72 65 74 75 | 72 6e 65 64 00 05 76 61 | is retu|rned..va|
|00000860| 6c 75 65 00 43 52 65 74 | 75 72 6e 73 20 54 52 55 |lue.CRet|urns TRU|
|00000870| 45 20 69 66 20 56 61 6c | 75 65 20 69 73 20 74 68 |E if Val|ue is th|
|00000880| 65 20 23 4e 2f 41 20 28 | 76 61 6c 75 65 20 6e 6f |e #N/A (|value no|
|00000890| 74 20 61 76 61 69 6c 61 | 62 6c 65 29 20 65 72 72 |t availa|ble) err|
|000008a0| 6f 72 20 76 61 6c 75 65 | 77 69 73 20 74 68 65 20 |or value|wis the |
|000008b0| 76 61 6c 75 65 20 79 6f | 75 20 77 61 6e 74 20 74 |value yo|u want t|
|000008c0| 6f 20 74 65 73 74 2e 20 | 56 61 6c 75 65 20 63 61 |o test. |Value ca|
|000008d0| 6e 20 72 65 66 65 72 20 | 74 6f 20 61 20 63 65 6c |n refer |to a cel|
|000008e0| 6c 2c 20 61 20 66 6f 72 | 6d 75 6c 61 2c 20 6f 72 |l, a for|mula, or|
|000008f0| 20 61 20 6e 61 6d 65 20 | 74 68 61 74 20 72 65 66 | a name |that ref|
|00000900| 65 72 73 20 74 6f 20 61 | 20 63 65 6c 6c 2c 20 66 |ers to a| cell, f|
|00000910| 6f 72 6d 75 6c 61 2c 20 | 6f 72 20 76 61 6c 75 65 |ormula, |or value|
|00000920| 00 05 76 61 6c 75 65 00 | 61 52 65 74 75 72 6e 73 |..value.|aReturns|
|00000930| 20 54 52 55 45 20 69 66 | 20 56 61 6c 75 65 20 69 | TRUE if| Value i|
|00000940| 73 20 61 6e 79 20 65 72 | 72 6f 72 20 76 61 6c 75 |s any er|ror valu|
|00000950| 65 20 28 23 4e 2f 41 2c | 20 23 56 41 4c 55 45 21 |e (#N/A,| #VALUE!|
|00000960| 2c 20 23 52 45 46 21 2c | 20 23 44 49 56 2f 30 21 |, #REF!,| #DIV/0!|
|00000970| 2c 20 23 4e 55 4d 21 2c | 20 23 4e 41 4d 45 3f 2c |, #NUM!,| #NAME?,|
|00000980| 20 6f 72 20 23 4e 55 4c | 4c 29 77 69 73 20 74 68 | or #NUL|L)wis th|
|00000990| 65 20 76 61 6c 75 65 20 | 79 6f 75 20 77 61 6e 74 |e value |you want|
|000009a0| 20 74 6f 20 74 65 73 74 | 2e 20 56 61 6c 75 65 20 | to test|. Value |
|000009b0| 63 61 6e 20 72 65 66 65 | 72 20 74 6f 20 61 20 63 |can refe|r to a c|
|000009c0| 65 6c 6c 2c 20 61 20 66 | 6f 72 6d 75 6c 61 2c 20 |ell, a f|ormula, |
|000009d0| 6f 72 20 61 20 6e 61 6d | 65 20 74 68 61 74 20 72 |or a nam|e that r|
|000009e0| 65 66 65 72 73 20 74 6f | 20 61 20 63 65 6c 6c 2c |efers to| a cell,|
|000009f0| 20 66 6f 72 6d 75 6c 61 | 2c 20 6f 72 20 76 61 6c | formula|, or val|
|00000a00| 75 65 00 13 6e 75 6d 62 | 65 72 31 2c 6e 75 6d 62 |ue..numb|er1,numb|
|00000a10| 65 72 32 2c 2e 2e 2e 00 | 28 41 64 64 73 20 61 6c |er2,....|(Adds al|
|00000a20| 6c 20 74 68 65 20 6e 75 | 6d 62 65 72 73 20 69 6e |l the nu|mbers in|
|00000a30| 20 61 20 72 61 6e 67 65 | 20 6f 66 20 63 65 6c 6c | a range| of cell|
|00000a40| 73 68 61 72 65 20 31 20 | 74 6f 20 33 30 20 6e 75 |share 1 |to 30 nu|
|00000a50| 6d 62 65 72 73 20 74 6f | 20 73 75 6d 2e 20 4c 6f |mbers to| sum. Lo|
|00000a60| 67 69 63 61 6c 20 76 61 | 6c 75 65 73 20 61 6e 64 |gical va|lues and|
|00000a70| 20 74 65 78 74 20 61 72 | 65 20 69 67 6e 6f 72 65 | text ar|e ignore|
|00000a80| 64 20 69 6e 20 63 65 6c | 6c 73 2c 20 69 6e 63 6c |d in cel|ls, incl|
|00000a90| 75 64 65 64 20 69 66 20 | 74 79 70 65 64 20 61 73 |uded if |typed as|
|00000aa0| 20 61 72 67 75 6d 65 6e | 74 73 00 13 6e 75 6d 62 | argumen|ts..numb|
|00000ab0| 65 72 31 2c 6e 75 6d 62 | 65 72 32 2c 2e 2e 2e 00 |er1,numb|er2,....|
|00000ac0| 81 52 65 74 75 72 6e 73 | 20 74 68 65 20 61 76 65 |.Returns| the ave|
|00000ad0| 72 61 67 65 20 28 61 72 | 69 74 68 6d 65 74 69 63 |rage (ar|ithmetic|
|00000ae0| 20 6d 65 61 6e 29 20 6f | 66 20 69 74 73 20 61 72 | mean) o|f its ar|
|00000af0| 67 75 6d 65 6e 74 73 2c | 20 77 68 69 63 68 20 63 |guments,| which c|
|00000b00| 61 6e 20 62 65 20 6e 75 | 6d 62 65 72 73 20 6f 72 |an be nu|mbers or|
|00000b10| 20 6e 61 6d 65 73 2c 20 | 61 72 72 61 79 73 2c 20 | names, |arrays, |
|00000b20| 6f 72 20 72 65 66 65 72 | 65 6e 63 65 73 20 74 68 |or refer|ences th|
|00000b30| 61 74 20 63 6f 6e 74 61 | 69 6e 20 6e 75 6d 62 65 |at conta|in numbe|
|00000b40| 72 73 3c 61 72 65 20 31 | 20 74 6f 20 33 30 20 6e |rs<are 1| to 30 n|
|00000b50| 75 6d 65 72 69 63 20 61 | 72 67 75 6d 65 6e 74 73 |umeric a|rguments|
|00000b60| 20 66 6f 72 20 77 68 69 | 63 68 20 79 6f 75 20 77 | for whi|ch you w|
|00000b70| 61 6e 74 20 74 68 65 20 | 61 76 65 72 61 67 65 00 |ant the |average.|
|00000b80| 13 6e 75 6d 62 65 72 31 | 2c 6e 75 6d 62 65 72 32 |.number1|,number2|
|00000b90| 2c 2e 2e 2e 00 4f 52 65 | 74 75 72 6e 73 20 74 68 |,....ORe|turns th|
|00000ba0| 65 20 73 6d 61 6c 6c 65 | 73 74 20 6e 75 6d 62 65 |e smalle|st numbe|
|00000bb0| 72 20 69 6e 20 61 20 73 | 65 74 20 6f 66 20 76 61 |r in a s|et of va|
|00000bc0| 6c 75 65 73 2e 20 49 67 | 6e 6f 72 65 73 20 6c 6f |lues. Ig|nores lo|
|00000bd0| 67 69 63 61 6c 20 76 61 | 6c 75 65 73 20 61 6e 64 |gical va|lues and|
|00000be0| 20 74 65 78 74 60 61 72 | 65 20 31 20 74 6f 20 33 | text`ar|e 1 to 3|
|00000bf0| 30 20 6e 75 6d 62 65 72 | 73 2c 20 65 6d 70 74 79 |0 number|s, empty|
|00000c00| 20 63 65 6c 6c 73 2c 20 | 6c 6f 67 69 63 61 6c 20 | cells, |logical |
|00000c10| 76 61 6c 75 65 73 2c 20 | 6f 72 20 74 65 78 74 20 |values, |or text |
|00000c20| 6e 75 6d 62 65 72 73 20 | 66 6f 72 20 77 68 69 63 |numbers |for whic|
|00000c30| 68 20 79 6f 75 20 77 61 | 6e 74 20 74 68 65 20 6d |h you wa|nt the m|
|00000c40| 69 6e 69 6d 75 6d 00 13 | 6e 75 6d 62 65 72 31 2c |inimum..|number1,|
|00000c50| 6e 75 6d 62 65 72 32 2c | 2e 2e 2e 00 4d 52 65 74 |number2,|....MRet|
|00000c60| 75 72 6e 73 20 74 68 65 | 20 6c 61 72 67 65 73 74 |urns the| largest|
|00000c70| 20 76 61 6c 75 65 20 69 | 6e 20 61 20 73 65 74 20 | value i|n a set |
|00000c80| 6f 66 20 76 61 6c 75 65 | 73 2e 20 49 67 6e 6f 72 |of value|s. Ignor|
|00000c90| 65 73 20 6c 6f 67 69 63 | 61 6c 20 76 61 6c 75 65 |es logic|al value|
|00000ca0| 73 20 61 6e 64 20 74 65 | 78 74 60 61 72 65 20 31 |s and te|xt`are 1|
|00000cb0| 20 74 6f 20 33 30 20 6e | 75 6d 62 65 72 73 2c 20 | to 30 n|umbers, |
|00000cc0| 65 6d 70 74 79 20 63 65 | 6c 6c 73 2c 20 6c 6f 67 |empty ce|lls, log|
|00000cd0| 69 63 61 6c 20 76 61 6c | 75 65 73 2c 20 6f 72 20 |ical val|ues, or |
|00000ce0| 74 65 78 74 20 6e 75 6d | 62 65 72 73 20 66 6f 72 |text num|bers for|
|00000cf0| 20 77 68 69 63 68 20 79 | 6f 75 20 77 61 6e 74 20 | which y|ou want |
|00000d00| 74 68 65 20 6d 61 78 69 | 6d 75 6d 00 09 72 65 66 |the maxi|mum..ref|
|00000d10| 65 72 65 6e 63 65 00 25 | 52 65 74 75 72 6e 73 20 |erence.%|Returns |
|00000d20| 74 68 65 20 72 6f 77 20 | 6e 75 6d 62 65 72 20 6f |the row |number o|
|00000d30| 66 20 61 20 72 65 66 65 | 72 65 6e 63 65 82 69 73 |f a refe|rence.is|
|00000d40| 20 74 68 65 20 63 65 6c | 6c 20 6f 72 20 61 20 73 | the cel|l or a s|
|00000d50| 69 6e 67 6c 65 20 72 61 | 6e 67 65 20 6f 66 20 63 |ingle ra|nge of c|
|00000d60| 65 6c 6c 73 20 66 6f 72 | 20 77 68 69 63 68 20 79 |ells for| which y|
|00000d70| 6f 75 20 77 61 6e 74 20 | 74 68 65 20 72 6f 77 20 |ou want |the row |
|00000d80| 6e 75 6d 62 65 72 3b 20 | 69 66 20 6f 6d 69 74 74 |number; |if omitt|
|00000d90| 65 64 2c 20 72 65 74 75 | 72 6e 73 20 74 68 65 20 |ed, retu|rns the |
|00000da0| 63 65 6c 6c 20 63 6f 6e | 74 61 69 6e 69 6e 67 20 |cell con|taining |
|00000db0| 74 68 65 20 52 4f 57 20 | 66 75 6e 63 74 69 6f 6e |the ROW |function|
|00000dc0| 00 09 72 65 66 65 72 65 | 6e 63 65 00 28 52 65 74 |..refere|nce.(Ret|
|00000dd0| 75 72 6e 73 20 74 68 65 | 20 63 6f 6c 75 6d 6e 20 |urns the| column |
|00000de0| 6e 75 6d 62 65 72 20 6f | 66 20 61 20 72 65 66 65 |number o|f a refe|
|00000df0| 72 65 6e 63 65 8a 69 73 | 20 74 68 65 20 63 65 6c |rence.is| the cel|
|00000e00| 6c 20 6f 72 20 72 61 6e | 67 65 20 6f 66 20 63 6f |l or ran|ge of co|
|00000e10| 6e 74 69 67 75 6f 75 73 | 20 63 65 6c 6c 73 20 66 |ntiguous| cells f|
|00000e20| 6f 72 20 77 68 69 63 68 | 20 79 6f 75 20 77 61 6e |or which| you wan|
|00000e30| 74 20 74 68 65 20 63 6f | 6c 75 6d 6e 20 6e 75 6d |t the co|lumn num|
|00000e40| 62 65 72 2e 20 49 66 20 | 6f 6d 69 74 74 65 64 2c |ber. If |omitted,|
|00000e50| 20 74 68 65 20 63 65 6c | 6c 20 63 6f 6e 74 61 69 | the cel|l contai|
|00000e60| 6e 69 6e 67 20 74 68 65 | 20 43 4f 4c 55 4d 4e 20 |ning the| COLUMN |
|00000e70| 66 75 6e 63 74 69 6f 6e | 20 69 73 20 75 73 65 64 |function| is used|
|00000e80| 00 00 32 52 65 74 75 72 | 6e 73 20 74 68 65 20 65 |..2Retur|ns the e|
|00000e90| 72 72 6f 72 20 76 61 6c | 75 65 20 23 4e 2f 41 20 |rror val|ue #N/A |
|00000ea0| 28 76 61 6c 75 65 20 6e | 6f 74 20 61 76 61 69 6c |(value n|ot avail|
|00000eb0| 61 62 6c 65 29 00 16 72 | 61 74 65 2c 76 61 6c 75 |able)..r|ate,valu|
|00000ec0| 65 31 2c 76 61 6c 75 65 | 32 2c 2e 2e 2e 00 96 52 |e1,value|2,.....R|
|00000ed0| 65 74 75 72 6e 73 20 74 | 68 65 20 6e 65 74 20 70 |eturns t|he net p|
|00000ee0| 72 65 73 65 6e 74 20 76 | 61 6c 75 65 20 6f 66 20 |resent v|alue of |
|00000ef0| 61 6e 20 69 6e 76 65 73 | 74 6d 65 6e 74 20 62 61 |an inves|tment ba|
|00000f00| 73 65 64 20 6f 6e 20 61 | 20 64 69 73 63 6f 75 6e |sed on a| discoun|
|00000f10| 74 20 72 61 74 65 20 61 | 6e 64 20 61 20 73 65 72 |t rate a|nd a ser|
|00000f20| 69 65 73 20 6f 66 20 66 | 75 74 75 72 65 20 70 61 |ies of f|uture pa|
|00000f30| 79 6d 65 6e 74 73 20 28 | 6e 65 67 61 74 69 76 65 |yments (|negative|
|00000f40| 20 76 61 6c 75 65 73 29 | 20 61 6e 64 20 69 6e 63 | values)| and inc|
|00000f50| 6f 6d 65 20 28 70 6f 73 | 69 74 69 76 65 20 76 61 |ome (pos|itive va|
|00000f60| 6c 75 65 73 29 35 69 73 | 20 74 68 65 20 72 61 74 |lues)5is| the rat|
|00000f70| 65 20 6f 66 20 64 69 73 | 63 6f 75 6e 74 20 6f 76 |e of dis|count ov|
|00000f80| 65 72 20 74 68 65 20 6c | 65 6e 67 74 68 20 6f 66 |er the l|ength of|
|00000f90| 20 6f 6e 65 20 70 65 72 | 69 6f 64 5f 61 72 65 20 | one per|iod_are |
|00000fa0| 31 20 74 6f 20 32 39 20 | 70 61 79 6d 65 6e 74 73 |1 to 29 |payments|
|00000fb0| 20 61 6e 64 20 69 6e 63 | 6f 6d 65 2c 20 65 71 75 | and inc|ome, equ|
|00000fc0| 61 6c 6c 79 20 73 70 61 | 63 65 64 20 69 6e 20 74 |ally spa|ced in t|
|00000fd0| 69 6d 65 20 61 6e 64 20 | 6f 63 63 75 72 72 69 6e |ime and |occurrin|
|00000fe0| 67 20 61 74 20 74 68 65 | 20 65 6e 64 20 6f 66 20 |g at the| end of |
|00000ff0| 65 61 63 68 20 70 65 72 | 69 6f 64 00 13 6e 75 6d |each per|iod..num|
|00001000| 62 65 72 31 2c 6e 75 6d | 62 65 72 32 2c 2e 2e 2e |ber1,num|ber2,...|
|00001010| 00 5e 45 73 74 69 6d 61 | 74 65 73 20 73 74 61 6e |.^Estima|tes stan|
|00001020| 64 61 72 64 20 64 65 76 | 69 61 74 69 6f 6e 20 62 |dard dev|iation b|
|00001030| 61 73 65 64 20 6f 6e 20 | 61 20 73 61 6d 70 6c 65 |ased on |a sample|
|00001040| 20 28 69 67 6e 6f 72 65 | 73 20 6c 6f 67 69 63 61 | (ignore|s logica|
|00001050| 6c 20 76 61 6c 75 65 73 | 20 61 6e 64 20 74 65 78 |l values| and tex|
|00001060| 74 20 69 6e 20 74 68 65 | 20 73 61 6d 70 6c 65 29 |t in the| sample)|
|00001070| 73 61 72 65 20 31 20 74 | 6f 20 33 30 20 6e 75 6d |sare 1 t|o 30 num|
|00001080| 62 65 72 73 20 63 6f 72 | 72 65 73 70 6f 6e 64 69 |bers cor|respondi|
|00001090| 6e 67 20 74 6f 20 61 20 | 73 61 6d 70 6c 65 20 6f |ng to a |sample o|
|000010a0| 66 20 61 20 70 6f 70 75 | 6c 61 74 69 6f 6e 20 61 |f a popu|lation a|
|000010b0| 6e 64 20 63 61 6e 20 62 | 65 20 6e 75 6d 62 65 72 |nd can b|e number|
|000010c0| 73 20 6f 72 20 72 65 66 | 65 72 65 6e 63 65 73 20 |s or ref|erences |
|000010d0| 74 68 61 74 20 63 6f 6e | 74 61 69 6e 20 6e 75 6d |that con|tain num|
|000010e0| 62 65 72 73 00 0f 6e 75 | 6d 62 65 72 2c 64 65 63 |bers..nu|mber,dec|
|000010f0| 69 6d 61 6c 73 00 30 43 | 6f 6e 76 65 72 74 73 20 |imals.0C|onverts |
|00001100| 61 20 6e 75 6d 62 65 72 | 20 74 6f 20 74 65 78 74 |a number| to text|
|00001110| 2c 20 75 73 69 6e 67 20 | 63 75 72 72 65 6e 63 79 |, using |currency|
|00001120| 20 66 6f 72 6d 61 74 5f | 69 73 20 61 20 6e 75 6d | format_|is a num|
|00001130| 62 65 72 2c 20 61 20 72 | 65 66 65 72 65 6e 63 65 |ber, a r|eference|
|00001140| 20 74 6f 20 61 20 63 65 | 6c 6c 20 63 6f 6e 74 61 | to a ce|ll conta|
|00001150| 69 6e 69 6e 67 20 61 20 | 6e 75 6d 62 65 72 2c 20 |ining a |number, |
|00001160| 6f 72 20 61 20 66 6f 72 | 6d 75 6c 61 20 74 68 61 |or a for|mula tha|
|00001170| 74 20 65 76 61 6c 75 61 | 74 65 73 20 74 6f 20 61 |t evalua|tes to a|
|00001180| 20 6e 75 6d 62 65 72 77 | 69 73 20 74 68 65 20 6e | numberw|is the n|
|00001190| 75 6d 62 65 72 20 6f 66 | 20 64 69 67 69 74 73 20 |umber of| digits |
|000011a0| 74 6f 20 74 68 65 20 72 | 69 67 68 74 20 6f 66 20 |to the r|ight of |
|000011b0| 74 68 65 20 64 65 63 69 | 6d 61 6c 20 70 6f 69 6e |the deci|mal poin|
|000011c0| 74 2e 20 54 68 65 20 6e | 75 6d 62 65 72 20 69 73 |t. The n|umber is|
|000011d0| 20 72 6f 75 6e 64 65 64 | 20 61 73 20 6e 65 63 65 | rounded| as nece|
|000011e0| 73 73 61 72 79 3b 20 69 | 66 20 6f 6d 69 74 74 65 |ssary; i|f omitte|
|000011f0| 64 2c 20 44 65 63 69 6d | 61 6c 73 20 3d 20 32 00 |d, Decim|als = 2.|
|00001200| 19 6e 75 6d 62 65 72 2c | 64 65 63 69 6d 61 6c 73 |.number,|decimals|
|00001210| 2c 6e 6f 5f 63 6f 6d 6d | 61 73 00 69 52 6f 75 6e |,no_comm|as.iRoun|
|00001220| 64 73 20 61 20 6e 75 6d | 62 65 72 20 74 6f 20 74 |ds a num|ber to t|
|00001230| 68 65 20 73 70 65 63 69 | 66 69 65 64 20 6e 75 6d |he speci|fied num|
|00001240| 62 65 72 20 6f 66 20 64 | 65 63 69 6d 61 6c 73 20 |ber of d|ecimals |
|00001250| 61 6e 64 20 72 65 74 75 | 72 6e 73 20 74 68 65 20 |and retu|rns the |
|00001260| 72 65 73 75 6c 74 20 61 | 73 20 74 65 78 74 20 77 |result a|s text w|
|00001270| 69 74 68 20 6f 72 20 77 | 69 74 68 6f 75 74 20 63 |ith or w|ithout c|
|00001280| 6f 6d 6d 61 73 33 69 73 | 20 74 68 65 20 6e 75 6d |ommas3is| the num|
|00001290| 62 65 72 20 79 6f 75 20 | 77 61 6e 74 20 74 6f 20 |ber you |want to |
|000012a0| 72 6f 75 6e 64 20 61 6e | 64 20 63 6f 6e 76 65 72 |round an|d conver|
|000012b0| 74 20 74 6f 20 74 65 78 | 74 53 69 73 20 74 68 65 |t to tex|tSis the|
|000012c0| 20 6e 75 6d 62 65 72 20 | 6f 66 20 64 69 67 69 74 | number |of digit|
|000012d0| 73 20 74 6f 20 74 68 65 | 20 72 69 67 68 74 20 6f |s to the| right o|
|000012e0| 66 20 74 68 65 20 64 65 | 63 69 6d 61 6c 20 70 6f |f the de|cimal po|
|000012f0| 69 6e 74 2e 20 49 66 20 | 6f 6d 69 74 74 65 64 2c |int. If |omitted,|
|00001300| 20 44 65 63 69 6d 61 6c | 73 20 3d 20 32 80 69 73 | Decimal|s = 2.is|
|00001310| 20 61 20 6c 6f 67 69 63 | 61 6c 20 76 61 6c 75 65 | a logic|al value|
|00001320| 3a 20 64 6f 20 6e 6f 74 | 20 64 69 73 70 6c 61 79 |: do not| display|
|00001330| 20 63 6f 6d 6d 61 73 20 | 69 6e 20 74 68 65 20 72 | commas |in the r|
|00001340| 65 74 75 72 6e 65 64 20 | 74 65 78 74 20 3d 20 54 |eturned |text = T|
|00001350| 52 55 45 3b 20 64 6f 20 | 64 69 73 70 6c 61 79 20 |RUE; do |display |
|00001360| 63 6f 6d 6d 61 73 20 69 | 6e 20 74 68 65 20 72 65 |commas i|n the re|
|00001370| 74 75 72 6e 65 64 20 74 | 65 78 74 20 3d 20 46 41 |turned t|ext = FA|
|00001380| 4c 53 45 20 6f 72 20 6f | 6d 69 74 74 65 64 00 06 |LSE or o|mitted..|
|00001390| 6e 75 6d 62 65 72 00 1c | 52 65 74 75 72 6e 73 20 |number..|Returns |
|000013a0| 74 68 65 20 73 69 6e 65 | 20 6f 66 20 61 6e 20 61 |the sine| of an a|
|000013b0| 6e 67 6c 65 51 69 73 20 | 74 68 65 20 61 6e 67 6c |ngleQis |the angl|
|000013c0| 65 20 69 6e 20 72 61 64 | 69 61 6e 73 20 66 6f 72 |e in rad|ians for|
|000013d0| 20 77 68 69 63 68 20 79 | 6f 75 20 77 61 6e 74 20 | which y|ou want |
|000013e0| 74 68 65 20 73 69 6e 65 | 2e 20 44 65 67 72 65 65 |the sine|. Degree|
|000013f0| 73 20 2a 20 50 49 28 29 | 2f 31 38 30 20 3d 20 72 |s * PI()|/180 = r|
|00001400| 61 64 69 61 6e 73 00 06 | 6e 75 6d 62 65 72 00 1e |adians..|number..|
|00001410| 52 65 74 75 72 6e 73 20 | 74 68 65 20 63 6f 73 69 |Returns |the cosi|
|00001420| 6e 65 20 6f 66 20 61 6e | 20 61 6e 67 6c 65 35 69 |ne of an| angle5i|
|00001430| 73 20 74 68 65 20 61 6e | 67 6c 65 20 69 6e 20 72 |s the an|gle in r|
|00001440| 61 64 69 61 6e 73 20 66 | 6f 72 20 77 68 69 63 68 |adians f|or which|
|00001450| 20 79 6f 75 20 77 61 6e | 74 20 74 68 65 20 63 6f | you wan|t the co|
|00001460| 73 69 6e 65 00 06 6e 75 | 6d 62 65 72 00 1f 52 65 |sine..nu|mber..Re|
|00001470| 74 75 72 6e 73 20 74 68 | 65 20 74 61 6e 67 65 6e |turns th|e tangen|
|00001480| 74 20 6f 66 20 61 6e 20 | 61 6e 67 6c 65 54 69 73 |t of an |angleTis|
|00001490| 20 74 68 65 20 61 6e 67 | 6c 65 20 69 6e 20 72 61 | the ang|le in ra|
|000014a0| 64 69 61 6e 73 20 66 6f | 72 20 77 68 69 63 68 20 |dians fo|r which |
|000014b0| 79 6f 75 20 77 61 6e 74 | 20 74 68 65 20 74 61 6e |you want| the tan|
|000014c0| 67 65 6e 74 2e 20 44 65 | 67 72 65 65 73 20 2a 20 |gent. De|grees * |
|000014d0| 50 49 28 29 2f 31 38 30 | 20 3d 20 72 61 64 69 61 |PI()/180| = radia|
|000014e0| 6e 73 00 06 6e 75 6d 62 | 65 72 00 49 52 65 74 75 |ns..numb|er.IRetu|
|000014f0| 72 6e 73 20 74 68 65 20 | 61 72 63 74 61 6e 67 65 |rns the |arctange|
|00001500| 6e 74 20 6f 66 20 61 20 | 6e 75 6d 62 65 72 20 69 |nt of a |number i|
|00001510| 6e 20 72 61 64 69 61 6e | 73 2c 20 69 6e 20 74 68 |n radian|s, in th|
|00001520| 65 20 72 61 6e 67 65 20 | 2d 50 69 2f 32 20 74 6f |e range |-Pi/2 to|
|00001530| 20 50 69 2f 32 24 69 73 | 20 74 68 65 20 74 61 6e | Pi/2$is| the tan|
|00001540| 67 65 6e 74 20 6f 66 20 | 74 68 65 20 61 6e 67 6c |gent of |the angl|
|00001550| 65 20 79 6f 75 20 77 61 | 6e 74 00 00 40 52 65 74 |e you wa|nt..@Ret|
|00001560| 75 72 6e 73 20 74 68 65 | 20 76 61 6c 75 65 20 6f |urns the| value o|
|00001570| 66 20 50 69 2c 20 33 2e | 31 34 31 35 39 32 36 35 |f Pi, 3.|14159265|
|00001580| 33 35 38 39 37 39 2c 20 | 61 63 63 75 72 61 74 65 |358979, |accurate|
|00001590| 20 74 6f 20 31 35 20 64 | 69 67 69 74 73 00 06 6e | to 15 d|igits..n|
|000015a0| 75 6d 62 65 72 00 21 52 | 65 74 75 72 6e 73 20 61 |umber.!R|eturns a|
|000015b0| 20 73 71 75 61 72 65 20 | 72 6f 6f 74 20 6f 66 20 | square |root of |
|000015c0| 61 20 6e 75 6d 62 65 72 | 30 69 73 20 74 68 65 20 |a number|0is the |
|000015d0| 6e 75 6d 62 65 72 20 66 | 6f 72 20 77 68 69 63 68 |number f|or which|
|000015e0| 20 79 6f 75 20 77 61 6e | 74 20 74 68 65 20 73 71 | you wan|t the sq|
|000015f0| 75 61 72 65 20 72 6f 6f | 74 00 06 6e 75 6d 62 65 |uare roo|t..numbe|
|00001600| 72 00 2f 52 65 74 75 72 | 6e 73 20 65 20 72 61 69 |r./Retur|ns e rai|
|00001610| 73 65 64 20 74 6f 20 74 | 68 65 20 70 6f 77 65 72 |sed to t|he power|
|00001620| 20 6f 66 20 61 20 67 69 | 76 65 6e 20 6e 75 6d 62 | of a gi|ven numb|
|00001630| 65 72 70 69 73 20 74 68 | 65 20 65 78 70 6f 6e 65 |erpis th|e expone|
|00001640| 6e 74 20 61 70 70 6c 69 | 65 64 20 74 6f 20 74 68 |nt appli|ed to th|
|00001650| 65 20 62 61 73 65 20 65 | 2e 20 54 68 65 20 63 6f |e base e|. The co|
|00001660| 6e 73 74 61 6e 74 20 65 | 20 65 71 75 61 6c 73 20 |nstant e| equals |
|00001670| 32 2e 37 31 38 32 38 31 | 38 32 38 34 35 39 30 34 |2.718281|82845904|
|00001680| 2c 20 74 68 65 20 62 61 | 73 65 20 6f 66 20 74 68 |, the ba|se of th|
|00001690| 65 20 6e 61 74 75 72 61 | 6c 20 6c 6f 67 61 72 69 |e natura|l logari|
|000016a0| 74 68 6d 00 06 6e 75 6d | 62 65 72 00 29 52 65 74 |thm..num|ber.)Ret|
|000016b0| 75 72 6e 73 20 74 68 65 | 20 6e 61 74 75 72 61 6c |urns the| natural|
|000016c0| 20 6c 6f 67 61 72 69 74 | 68 6d 20 6f 66 20 61 20 | logarit|hm of a |
|000016d0| 6e 75 6d 62 65 72 44 69 | 73 20 74 68 65 20 70 6f |numberDi|s the po|
|000016e0| 73 69 74 69 76 65 20 72 | 65 61 6c 20 6e 75 6d 62 |sitive r|eal numb|
|000016f0| 65 72 20 66 6f 72 20 77 | 68 69 63 68 20 79 6f 75 |er for w|hich you|
|00001700| 20 77 61 6e 74 20 74 68 | 65 20 6e 61 74 75 72 61 | want th|e natura|
|00001710| 6c 20 6c 6f 67 61 72 69 | 74 68 6d 00 06 6e 75 6d |l logari|thm..num|
|00001720| 62 65 72 00 29 52 65 74 | 75 72 6e 73 20 74 68 65 |ber.)Ret|urns the|
|00001730| 20 62 61 73 65 2d 31 30 | 20 6c 6f 67 61 72 69 74 | base-10| logarit|
|00001740| 68 6d 20 6f 66 20 61 20 | 6e 75 6d 62 65 72 44 69 |hm of a |numberDi|
|00001750| 73 20 74 68 65 20 70 6f | 73 69 74 69 76 65 20 72 |s the po|sitive r|
|00001760| 65 61 6c 20 6e 75 6d 62 | 65 72 20 66 6f 72 20 77 |eal numb|er for w|
|00001770| 68 69 63 68 20 79 6f 75 | 20 77 61 6e 74 20 74 68 |hich you| want th|
|00001780| 65 20 62 61 73 65 2d 31 | 30 20 6c 6f 67 61 72 69 |e base-1|0 logari|
|00001790| 74 68 6d 00 06 6e 75 6d | 62 65 72 00 41 52 65 74 |thm..num|ber.ARet|
|000017a0| 75 72 6e 73 20 74 68 65 | 20 61 62 73 6f 6c 75 74 |urns the| absolut|
|000017b0| 65 20 76 61 6c 75 65 20 | 6f 66 20 61 20 6e 75 6d |e value |of a num|
|000017c0| 62 65 72 2c 20 61 20 6e | 75 6d 62 65 72 20 77 69 |ber, a n|umber wi|
|000017d0| 74 68 6f 75 74 20 69 74 | 73 20 73 69 67 6e 38 69 |thout it|s sign8i|
|000017e0| 73 20 74 68 65 20 72 65 | 61 6c 20 6e 75 6d 62 65 |s the re|al numbe|
|000017f0| 72 20 66 6f 72 20 77 68 | 69 63 68 20 79 6f 75 20 |r for wh|ich you |
|00001800| 77 61 6e 74 20 74 68 65 | 20 61 62 73 6f 6c 75 74 |want the| absolut|
|00001810| 65 20 76 61 6c 75 65 00 | 06 6e 75 6d 62 65 72 00 |e value.|.number.|
|00001820| 2b 52 6f 75 6e 64 73 20 | 61 20 6e 75 6d 62 65 72 |+Rounds |a number|
|00001830| 20 64 6f 77 6e 20 74 6f | 20 74 68 65 20 6e 65 61 | down to| the nea|
|00001840| 72 65 73 74 20 69 6e 74 | 65 67 65 72 37 69 73 20 |rest int|eger7is |
|00001850| 74 68 65 20 72 65 61 6c | 20 6e 75 6d 62 65 72 20 |the real| number |
|00001860| 79 6f 75 20 77 61 6e 74 | 20 74 6f 20 72 6f 75 6e |you want| to roun|
|00001870| 64 20 64 6f 77 6e 20 74 | 6f 20 61 6e 20 69 6e 74 |d down t|o an int|
|00001880| 65 67 65 72 00 06 6e 75 | 6d 62 65 72 00 76 52 65 |eger..nu|mber.vRe|
|00001890| 74 75 72 6e 73 20 74 68 | 65 20 73 69 67 6e 20 6f |turns th|e sign o|
|000018a0| 66 20 61 20 6e 75 6d 62 | 65 72 3a 20 31 20 69 66 |f a numb|er: 1 if|
|000018b0| 20 74 68 65 20 6e 75 6d | 62 65 72 20 69 73 20 70 | the num|ber is p|
|000018c0| 6f 73 69 74 69 76 65 2c | 20 7a 65 72 6f 20 69 66 |ositive,| zero if|
|000018d0| 20 74 68 65 20 6e 75 6d | 62 65 72 20 69 73 20 7a | the num|ber is z|
|000018e0| 65 72 6f 2c 20 6f 72 20 | 2d 31 20 69 66 20 74 68 |ero, or |-1 if th|
|000018f0| 65 20 6e 75 6d 62 65 72 | 20 69 73 20 6e 65 67 61 |e number| is nega|
|00001900| 74 69 76 65 12 69 73 20 | 61 6e 79 20 72 65 61 6c |tive.is |any real|
|00001910| 20 6e 75 6d 62 65 72 00 | 11 6e 75 6d 62 65 72 2c | number.|.number,|
|00001920| 6e 75 6d 5f 64 69 67 69 | 74 73 00 2f 52 6f 75 6e |num_digi|ts./Roun|
|00001930| 64 73 20 61 20 6e 75 6d | 62 65 72 20 74 6f 20 61 |ds a num|ber to a|
|00001940| 20 73 70 65 63 69 66 69 | 65 64 20 6e 75 6d 62 65 | specifi|ed numbe|
|00001950| 72 20 6f 66 20 64 69 67 | 69 74 73 1f 69 73 20 74 |r of dig|its.is t|
|00001960| 68 65 20 6e 75 6d 62 65 | 72 20 79 6f 75 20 77 61 |he numbe|r you wa|
|00001970| 6e 74 20 74 6f 20 72 6f | 75 6e 64 81 69 73 20 74 |nt to ro|und.is t|
|00001980| 68 65 20 6e 75 6d 62 65 | 72 20 6f 66 20 64 69 67 |he numbe|r of dig|
|00001990| 69 74 73 20 74 6f 20 77 | 68 69 63 68 20 79 6f 75 |its to w|hich you|
|000019a0| 20 77 61 6e 74 20 74 6f | 20 72 6f 75 6e 64 2e 20 | want to| round. |
|000019b0| 4e 65 67 61 74 69 76 65 | 20 72 6f 75 6e 64 73 20 |Negative| rounds |
|000019c0| 74 6f 20 74 68 65 20 6c | 65 66 74 20 6f 66 20 74 |to the l|eft of t|
|000019d0| 68 65 20 64 65 63 69 6d | 61 6c 20 70 6f 69 6e 74 |he decim|al point|
|000019e0| 3b 20 7a 65 72 6f 20 74 | 6f 20 74 68 65 20 6e 65 |; zero t|o the ne|
|000019f0| 61 72 65 73 74 20 69 6e | 74 65 67 65 72 00 28 6c |arest in|teger.(l|
|00001a00| 6f 6f 6b 75 70 5f 76 61 | 6c 75 65 2c 6c 6f 6f 6b |ookup_va|lue,look|
|00001a10| 75 70 5f 76 65 63 74 6f | 72 2c 72 65 73 75 6c 74 |up_vecto|r,result|
|00001a20| 5f 76 65 63 74 6f 72 12 | 6c 6f 6f 6b 75 70 5f 76 |_vector.|lookup_v|
|00001a30| 61 6c 75 65 2c 61 72 72 | 61 79 00 4a 52 65 74 75 |alue,arr|ay.JRetu|
|00001a40| 72 6e 73 20 61 20 76 61 | 6c 75 65 20 65 69 74 68 |rns a va|lue eith|
|00001a50| 65 72 20 66 72 6f 6d 20 | 61 20 6f 6e 65 2d 72 6f |er from |a one-ro|
|00001a60| 77 20 6f 72 20 6f 6e 65 | 2d 63 6f 6c 75 6d 6e 20 |w or one|-column |
|00001a70| 72 61 6e 67 65 20 6f 72 | 20 66 72 6f 6d 20 61 6e |range or| from an|
|00001a80| 20 61 72 72 61 79 82 69 | 73 20 61 20 76 61 6c 75 | array.i|s a valu|
|00001a90| 65 20 74 68 61 74 20 4c | 4f 4f 4b 55 50 20 73 65 |e that L|OOKUP se|
|00001aa0| 61 72 63 68 65 73 20 66 | 6f 72 20 69 6e 20 4c 6f |arches f|or in Lo|
|00001ab0| 6f 6b 75 70 5f 76 65 63 | 74 6f 72 20 61 6e 64 20 |okup_vec|tor and |
|00001ac0| 63 61 6e 20 62 65 20 61 | 20 6e 75 6d 62 65 72 2c |can be a| number,|
|00001ad0| 20 74 65 78 74 2c 20 61 | 20 6c 6f 67 69 63 61 6c | text, a| logical|
|00001ae0| 20 76 61 6c 75 65 2c 20 | 6f 72 20 61 20 6e 61 6d | value, |or a nam|
|00001af0| 65 20 6f 72 20 72 65 66 | 65 72 65 6e 63 65 20 74 |e or ref|erence t|
|00001b00| 6f 20 61 20 76 61 6c 75 | 65 72 69 73 20 61 20 72 |o a valu|eris a r|
|00001b10| 61 6e 67 65 20 74 68 61 | 74 20 63 6f 6e 74 61 69 |ange tha|t contai|
|00001b20| 6e 73 20 6f 6e 6c 79 20 | 6f 6e 65 20 72 6f 77 20 |ns only |one row |
|00001b30| 6f 72 20 6f 6e 65 20 63 | 6f 6c 75 6d 6e 20 6f 66 |or one c|olumn of|
|00001b40| 20 74 65 78 74 2c 20 6e | 75 6d 62 65 72 73 2c 20 | text, n|umbers, |
|00001b50| 6f 72 20 6c 6f 67 69 63 | 61 6c 20 76 61 6c 75 65 |or logic|al value|
|00001b60| 73 2c 20 70 6c 61 63 65 | 64 20 69 6e 20 61 73 63 |s, place|d in asc|
|00001b70| 65 6e 64 69 6e 67 20 6f | 72 64 65 72 4f 69 73 20 |ending o|rderOis |
|00001b80| 61 20 72 61 6e 67 65 20 | 74 68 61 74 20 63 6f 6e |a range |that con|
|00001b90| 74 61 69 6e 73 20 6f 6e | 6c 79 20 6f 6e 65 20 72 |tains on|ly one r|
|00001ba0| 6f 77 20 6f 72 20 63 6f | 6c 75 6d 6e 2c 20 74 68 |ow or co|lumn, th|
|00001bb0| 65 20 73 61 6d 65 20 73 | 69 7a 65 20 61 73 20 4c |e same s|ize as L|
|00001bc0| 6f 6f 6b 75 70 5f 76 65 | 63 74 6f 72 7a 69 73 20 |ookup_ve|ctorzis |
|00001bd0| 61 20 76 61 6c 75 65 20 | 74 68 61 74 20 4c 4f 4f |a value |that LOO|
|00001be0| 4b 55 50 20 73 65 61 72 | 63 68 65 73 20 66 6f 72 |KUP sear|ches for|
|00001bf0| 20 69 6e 20 41 72 72 61 | 79 20 61 6e 64 20 63 61 | in Arra|y and ca|
|00001c00| 6e 20 62 65 20 61 20 6e | 75 6d 62 65 72 2c 20 74 |n be a n|umber, t|
|00001c10| 65 78 74 2c 20 61 20 6c | 6f 67 69 63 61 6c 20 76 |ext, a l|ogical v|
|00001c20| 61 6c 75 65 2c 20 6f 72 | 20 61 20 6e 61 6d 65 20 |alue, or| a name |
|00001c30| 6f 72 20 72 65 66 65 72 | 65 6e 63 65 20 74 6f 20 |or refer|ence to |
|00001c40| 61 20 76 61 6c 75 65 6b | 69 73 20 61 20 72 61 6e |a valuek|is a ran|
|00001c50| 67 65 20 6f 66 20 63 65 | 6c 6c 73 20 74 68 61 74 |ge of ce|lls that|
|00001c60| 20 63 6f 6e 74 61 69 6e | 20 74 65 78 74 2c 20 6e | contain| text, n|
|00001c70| 75 6d 62 65 72 2c 20 6f | 72 20 6c 6f 67 69 63 61 |umber, o|r logica|
|00001c80| 6c 20 76 61 6c 75 65 73 | 20 74 68 61 74 20 79 6f |l values| that yo|
|00001c90| 75 20 77 61 6e 74 20 74 | 6f 20 63 6f 6d 70 61 72 |u want t|o compar|
|00001ca0| 65 20 77 69 74 68 20 4c | 6f 6f 6b 75 70 5f 76 61 |e with L|ookup_va|
|00001cb0| 6c 75 65 00 18 61 72 72 | 61 79 2c 72 6f 77 5f 6e |lue..arr|ay,row_n|
|00001cc0| 75 6d 2c 63 6f 6c 75 6d | 6e 5f 6e 75 6d 25 72 65 |um,colum|n_num%re|
|00001cd0| 66 65 72 65 6e 63 65 2c | 72 6f 77 5f 6e 75 6d 2c |ference,|row_num,|
|00001ce0| 63 6f 6c 75 6d 6e 5f 6e | 75 6d 2c 61 72 65 61 5f |column_n|um,area_|
|00001cf0| 6e 75 6d 00 48 52 65 74 | 75 72 6e 73 20 61 20 76 |num.HRet|urns a v|
|00001d00| 61 6c 75 65 20 6f 72 20 | 74 68 65 20 72 65 66 65 |alue or |the refe|
|00001d10| 72 65 6e 63 65 20 74 6f | 20 61 20 76 61 6c 75 65 |rence to| a value|
|00001d20| 20 66 72 6f 6d 20 77 69 | 74 68 69 6e 20 61 20 74 | from wi|thin a t|
|00001d30| 61 62 6c 65 20 6f 72 20 | 72 61 6e 67 65 58 69 73 |able or |rangeXis|
|00001d40| 20 61 20 72 61 6e 67 65 | 20 6f 66 20 63 65 6c 6c | a range| of cell|
|00001d50| 73 20 6f 72 20 61 6e 20 | 61 72 72 61 79 20 63 6f |s or an |array co|
|00001d60| 6e 73 74 61 6e 74 2e 20 | 53 65 65 20 48 65 6c 70 |nstant. |See Help|
|00001d70| 20 66 6f 72 20 69 6e 66 | 6f 72 6d 61 74 69 6f 6e | for inf|ormation|
|00001d80| 20 61 62 6f 75 74 20 61 | 72 72 61 79 20 63 6f 6e | about a|rray con|
|00001d90| 73 74 61 6e 74 73 66 73 | 65 6c 65 63 74 73 20 74 |stantsfs|elects t|
|00001da0| 68 65 20 72 6f 77 20 69 | 6e 20 41 72 72 61 79 20 |he row i|n Array |
|00001db0| 6f 72 20 52 65 66 65 72 | 65 6e 63 65 20 66 72 6f |or Refer|ence fro|
|00001dc0| 6d 20 77 68 69 63 68 20 | 74 6f 20 72 65 74 75 72 |m which |to retur|
|00001dd0| 6e 20 61 20 76 61 6c 75 | 65 2e 20 49 66 20 6f 6d |n a valu|e. If om|
|00001de0| 69 74 74 65 64 2c 20 43 | 6f 6c 75 6d 6e 5f 6e 75 |itted, C|olumn_nu|
|00001df0| 6d 20 69 73 20 72 65 71 | 75 69 72 65 64 66 73 65 |m is req|uiredfse|
|00001e00| 6c 65 63 74 73 20 74 68 | 65 20 63 6f 6c 75 6d 6e |lects th|e column|
|00001e10| 20 69 6e 20 41 72 72 61 | 79 20 6f 72 20 52 65 66 | in Arra|y or Ref|
|00001e20| 65 72 65 6e 63 65 20 66 | 72 6f 6d 20 77 68 69 63 |erence f|rom whic|
|00001e30| 68 20 74 6f 20 72 65 74 | 75 72 6e 20 61 20 76 61 |h to ret|urn a va|
|00001e40| 6c 75 65 2e 20 49 66 20 | 6f 6d 69 74 74 65 64 2c |lue. If |omitted,|
|00001e50| 20 52 6f 77 5f 6e 75 6d | 20 69 73 20 72 65 71 75 | Row_num| is requ|
|00001e60| 69 72 65 64 29 69 73 20 | 61 20 72 65 66 65 72 65 |ired)is |a refere|
|00001e70| 6e 63 65 20 74 6f 20 6f | 6e 65 20 6f 72 20 6d 6f |nce to o|ne or mo|
|00001e80| 72 65 20 63 65 6c 6c 20 | 72 61 6e 67 65 73 66 73 |re cell |rangesfs|
|00001e90| 65 6c 65 63 74 73 20 74 | 68 65 20 72 6f 77 20 69 |elects t|he row i|
|00001ea0| 6e 20 41 72 72 61 79 20 | 6f 72 20 52 65 66 65 72 |n Array |or Refer|
|00001eb0| 65 6e 63 65 20 66 72 6f | 6d 20 77 68 69 63 68 20 |ence fro|m which |
|00001ec0| 74 6f 20 72 65 74 75 72 | 6e 20 61 20 76 61 6c 75 |to retur|n a valu|
|00001ed0| 65 2e 20 49 66 20 6f 6d | 69 74 74 65 64 2c 20 43 |e. If om|itted, C|
|00001ee0| 6f 6c 75 6d 6e 5f 6e 75 | 6d 20 69 73 20 72 65 71 |olumn_nu|m is req|
|00001ef0| 75 69 72 65 64 66 73 65 | 6c 65 63 74 73 20 74 68 |uiredfse|lects th|
|00001f00| 65 20 63 6f 6c 75 6d 6e | 20 69 6e 20 41 72 72 61 |e column| in Arra|
|00001f10| 79 20 6f 72 20 52 65 66 | 65 72 65 6e 63 65 20 66 |y or Ref|erence f|
|00001f20| 72 6f 6d 20 77 68 69 63 | 68 20 74 6f 20 72 65 74 |rom whic|h to ret|
|00001f30| 75 72 6e 20 61 20 76 61 | 6c 75 65 2e 20 49 66 20 |urn a va|lue. If |
|00001f40| 6f 6d 69 74 74 65 64 2c | 20 52 6f 77 5f 6e 75 6d |omitted,| Row_num|
|00001f50| 20 69 73 20 72 65 71 75 | 69 72 65 64 8d 73 65 6c | is requ|ired.sel|
|00001f60| 65 63 74 73 20 61 20 72 | 61 6e 67 65 20 69 6e 20 |ects a r|ange in |
|00001f70| 52 65 66 65 72 65 6e 63 | 65 20 66 72 6f 6d 20 77 |Referenc|e from w|
|00001f80| 68 69 63 68 20 74 6f 20 | 72 65 74 75 72 6e 20 61 |hich to |return a|
|00001f90| 20 76 61 6c 75 65 2e 20 | 54 68 65 20 66 69 72 73 | value. |The firs|
|00001fa0| 74 20 61 72 65 61 20 73 | 65 6c 65 63 74 65 64 20 |t area s|elected |
|00001fb0| 6f 72 20 65 6e 74 65 72 | 65 64 20 69 73 20 61 72 |or enter|ed is ar|
|00001fc0| 65 61 20 31 2c 20 74 68 | 65 20 73 65 63 6f 6e 64 |ea 1, th|e second|
|00001fd0| 20 61 72 65 61 20 69 73 | 20 61 72 65 61 20 32 2c | area is| area 2,|
|00001fe0| 20 61 6e 64 20 73 6f 20 | 6f 6e 00 11 74 65 78 74 | and so |on..text|
|00001ff0| 2c 6e 75 6d 62 65 72 5f | 74 69 6d 65 73 00 69 52 |,number_|times.iR|
|00002000| 65 70 65 61 74 73 20 74 | 65 78 74 20 61 20 67 69 |epeats t|ext a gi|
|00002010| 76 65 6e 20 6e 75 6d 62 | 65 72 20 6f 66 20 74 69 |ven numb|er of ti|
|00002020| 6d 65 73 2e 20 55 73 65 | 20 52 45 50 54 20 74 6f |mes. Use| REPT to|
|00002030| 20 66 69 6c 6c 20 61 20 | 63 65 6c 6c 20 77 69 74 | fill a |cell wit|
|00002040| 68 20 61 20 6e 75 6d 62 | 65 72 20 6f 66 20 69 6e |h a numb|er of in|
|00002050| 73 74 61 6e 63 65 73 20 | 6f 66 20 61 20 74 65 78 |stances |of a tex|
|00002060| 74 20 73 74 72 69 6e 67 | 1e 69 73 20 74 68 65 20 |t string|.is the |
|00002070| 74 65 78 74 20 79 6f 75 | 20 77 61 6e 74 20 74 6f |text you| want to|
|00002080| 20 72 65 70 65 61 74 42 | 69 73 20 61 20 70 6f 73 | repeatB|is a pos|
|00002090| 69 74 69 76 65 20 6e 75 | 6d 62 65 72 20 73 70 65 |itive nu|mber spe|
|000020a0| 63 69 66 79 69 6e 67 20 | 74 68 65 20 6e 75 6d 62 |cifying |the numb|
|000020b0| 65 72 20 6f 66 20 74 69 | 6d 65 73 20 74 6f 20 72 |er of ti|mes to r|
|000020c0| 65 70 65 61 74 20 74 65 | 78 74 00 18 74 65 78 74 |epeat te|xt..text|
|000020d0| 2c 73 74 61 72 74 5f 6e | 75 6d 2c 6e 75 6d 5f 63 |,start_n|um,num_c|
|000020e0| 68 61 72 73 00 5f 52 65 | 74 75 72 6e 73 20 61 20 |hars._Re|turns a |
|000020f0| 73 70 65 63 69 66 69 63 | 20 6e 75 6d 62 65 72 20 |specific| number |
|00002100| 6f 66 20 63 68 61 72 61 | 63 74 65 72 73 20 66 72 |of chara|cters fr|
|00002110| 6f 6d 20 61 20 74 65 78 | 74 20 73 74 72 69 6e 67 |om a tex|t string|
|00002120| 20 73 74 61 72 74 69 6e | 67 20 61 74 20 74 68 65 | startin|g at the|
|00002130| 20 70 6f 73 69 74 69 6f | 6e 20 79 6f 75 20 73 70 | positio|n you sp|
|00002140| 65 63 69 66 79 40 69 73 | 20 74 68 65 20 74 65 78 |ecify@is| the tex|
|00002150| 74 20 73 74 72 69 6e 67 | 20 66 72 6f 6d 20 77 68 |t string| from wh|
|00002160| 69 63 68 20 79 6f 75 20 | 77 61 6e 74 20 74 6f 20 |ich you |want to |
|00002170| 65 78 74 72 61 63 74 20 | 74 68 65 20 63 68 61 72 |extract |the char|
|00002180| 61 63 74 65 72 73 5c 69 | 73 20 74 68 65 20 70 6f |acters\i|s the po|
|00002190| 73 69 74 69 6f 6e 20 6f | 66 20 74 68 65 20 66 69 |sition o|f the fi|
|000021a0| 72 73 74 20 63 68 61 72 | 61 63 74 65 72 20 79 6f |rst char|acter yo|
|000021b0| 75 20 77 61 6e 74 20 74 | 6f 20 65 78 74 72 61 63 |u want t|o extrac|
|000021c0| 74 2e 20 54 68 65 20 66 | 69 72 73 74 20 63 68 61 |t. The f|irst cha|
|000021d0| 72 61 63 74 65 72 20 69 | 6e 20 54 65 78 74 20 69 |racter i|n Text i|
|000021e0| 73 20 31 31 73 70 65 63 | 69 66 69 65 73 20 68 6f |s 11spec|ifies ho|
|000021f0| 77 20 6d 61 6e 79 20 63 | 68 61 72 61 63 74 65 72 |w many c|haracter|
|00002200| 73 20 74 6f 20 72 65 74 | 75 72 6e 20 66 72 6f 6d |s to ret|urn from|
|00002210| 20 54 65 78 74 00 04 74 | 65 78 74 00 31 52 65 74 | Text..t|ext.1Ret|
|00002220| 75 72 6e 73 20 74 68 65 | 20 6e 75 6d 62 65 72 20 |urns the| number |
|00002230| 6f 66 20 63 68 61 72 61 | 63 74 65 72 73 20 69 6e |of chara|cters in|
|00002240| 20 61 20 74 65 78 74 20 | 73 74 72 69 6e 67 45 69 | a text |stringEi|
|00002250| 73 20 74 68 65 20 74 65 | 78 74 20 77 68 6f 73 65 |s the te|xt whose|
|00002260| 20 6c 65 6e 67 74 68 20 | 79 6f 75 20 77 61 6e 74 | length |you want|
|00002270| 20 74 6f 20 66 69 6e 64 | 2e 20 53 70 61 63 65 73 | to find|. Spaces|
|00002280| 20 63 6f 75 6e 74 20 61 | 73 20 63 68 61 72 61 63 | count a|s charac|
|00002290| 74 65 72 73 00 04 74 65 | 78 74 00 3b 43 6f 6e 76 |ters..te|xt.;Conv|
|000022a0| 65 72 74 73 20 61 20 74 | 65 78 74 20 73 74 72 69 |erts a t|ext stri|
|000022b0| 6e 67 20 74 68 61 74 20 | 72 65 70 72 65 73 65 6e |ng that |represen|
|000022c0| 74 73 20 61 20 6e 75 6d | 62 65 72 20 74 6f 20 61 |ts a num|ber to a|
|000022d0| 20 6e 75 6d 62 65 72 68 | 69 73 20 74 68 65 20 74 | numberh|is the t|
|000022e0| 65 78 74 20 65 6e 63 6c | 6f 73 65 64 20 69 6e 20 |ext encl|osed in |
|000022f0| 71 75 6f 74 61 74 69 6f | 6e 20 6d 61 72 6b 73 20 |quotatio|n marks |
|00002300| 6f 72 20 61 20 72 65 66 | 65 72 65 6e 63 65 20 74 |or a ref|erence t|
|00002310| 6f 20 61 20 63 65 6c 6c | 20 63 6f 6e 74 61 69 6e |o a cell| contain|
|00002320| 69 6e 67 20 74 68 65 20 | 74 65 78 74 20 79 6f 75 |ing the |text you|
|00002330| 20 77 61 6e 74 20 74 6f | 20 63 6f 6e 76 65 72 74 | want to| convert|
|00002340| 00 00 1e 52 65 74 75 72 | 6e 73 20 74 68 65 20 6c |...Retur|ns the l|
|00002350| 6f 67 69 63 61 6c 20 76 | 61 6c 75 65 20 54 52 55 |ogical v|alue TRU|
|00002360| 45 00 00 1f 52 65 74 75 | 72 6e 73 20 74 68 65 20 |E...Retu|rns the |
|00002370| 6c 6f 67 69 63 61 6c 20 | 76 61 6c 75 65 20 46 41 |logical |value FA|
|00002380| 4c 53 45 00 15 6c 6f 67 | 69 63 61 6c 31 2c 6c 6f |LSE..log|ical1,lo|
|00002390| 67 69 63 61 6c 32 2c 2e | 2e 2e 00 52 52 65 74 75 |gical2,.|...RRetu|
|000023a0| 72 6e 73 20 54 52 55 45 | 20 69 66 20 61 6c 6c 20 |rns TRUE| if all |
|000023b0| 69 74 73 20 61 72 67 75 | 6d 65 6e 74 73 20 61 72 |its argu|ments ar|
|000023c0| 65 20 54 52 55 45 3b 20 | 72 65 74 75 72 6e 73 20 |e TRUE; |returns |
|000023d0| 46 41 4c 53 45 20 69 66 | 20 61 6e 79 20 61 72 67 |FALSE if| any arg|
|000023e0| 75 6d 65 6e 74 20 69 73 | 20 46 41 4c 53 45 79 61 |ument is| FALSEya|
|000023f0| 72 65 20 31 20 74 6f 20 | 33 30 20 63 6f 6e 64 69 |re 1 to |30 condi|
|00002400| 74 69 6f 6e 73 20 79 6f | 75 20 77 61 6e 74 20 74 |tions yo|u want t|
|00002410| 6f 20 74 65 73 74 20 74 | 68 61 74 20 63 61 6e 20 |o test t|hat can |
|00002420| 62 65 20 65 69 74 68 65 | 72 20 54 52 55 45 20 6f |be eithe|r TRUE o|
|00002430| 72 20 46 41 4c 53 45 20 | 61 6e 64 20 63 61 6e 20 |r FALSE |and can |
|00002440| 62 65 20 6c 6f 67 69 63 | 61 6c 20 76 61 6c 75 65 |be logic|al value|
|00002450| 73 2c 20 61 72 72 61 79 | 73 2c 20 6f 72 20 72 65 |s, array|s, or re|
|00002460| 66 65 72 65 6e 63 65 73 | 00 15 6c 6f 67 69 63 61 |ferences|..logica|
|00002470| 6c 31 2c 6c 6f 67 69 63 | 61 6c 32 2c 2e 2e 2e 00 |l1,logic|al2,....|
|00002480| 4e 52 65 74 75 72 6e 73 | 20 54 52 55 45 20 69 66 |NReturns| TRUE if|
|00002490| 20 61 6e 79 20 61 72 67 | 75 6d 65 6e 74 20 69 73 | any arg|ument is|
|000024a0| 20 54 52 55 45 3b 20 72 | 65 74 75 72 6e 73 20 46 | TRUE; r|eturns F|
|000024b0| 41 4c 53 45 20 69 66 20 | 61 6c 6c 20 61 72 67 75 |ALSE if |all argu|
|000024c0| 6d 65 6e 74 73 20 61 72 | 65 20 46 41 4c 53 45 4d |ments ar|e FALSEM|
|000024d0| 61 72 65 20 31 20 74 6f | 20 33 30 20 63 6f 6e 64 |are 1 to| 30 cond|
|000024e0| 69 74 69 6f 6e 73 20 74 | 68 61 74 20 79 6f 75 20 |itions t|hat you |
|000024f0| 77 61 6e 74 20 74 6f 20 | 74 65 73 74 20 74 68 61 |want to |test tha|
|00002500| 74 20 63 61 6e 20 62 65 | 20 65 69 74 68 65 72 20 |t can be| either |
|00002510| 54 52 55 45 20 6f 72 20 | 46 41 4c 53 45 00 07 6c |TRUE or |FALSE..l|
|00002520| 6f 67 69 63 61 6c 00 63 | 52 65 76 65 72 73 65 73 |ogical.c|Reverses|
|00002530| 20 74 68 65 20 6c 6f 67 | 69 63 20 6f 66 20 69 74 | the log|ic of it|
|00002540| 73 20 61 72 67 75 6d 65 | 6e 74 3a 20 72 65 74 75 |s argume|nt: retu|
|00002550| 72 6e 73 20 46 41 4c 53 | 45 20 66 6f 72 20 61 20 |rns FALS|E for a |
|00002560| 54 52 55 45 20 61 72 67 | 75 6d 65 6e 74 20 61 6e |TRUE arg|ument an|
|00002570| 64 20 54 52 55 45 20 66 | 6f 72 20 61 20 46 41 4c |d TRUE f|or a FAL|
|00002580| 53 45 20 61 72 67 75 6d | 65 6e 74 3f 69 73 20 61 |SE argum|ent?is a|
|00002590| 20 76 61 6c 75 65 20 6f | 72 20 65 78 70 72 65 73 | value o|r expres|
|000025a0| 73 69 6f 6e 20 74 68 61 | 74 20 63 61 6e 20 62 65 |sion tha|t can be|
|000025b0| 20 65 76 61 6c 75 61 74 | 65 64 20 74 6f 20 54 52 | evaluat|ed to TR|
|000025c0| 55 45 20 6f 72 20 46 41 | 4c 53 45 00 0e 6e 75 6d |UE or FA|LSE..num|
|000025d0| 62 65 72 2c 64 69 76 69 | 73 6f 72 00 3c 52 65 74 |ber,divi|sor.<Ret|
|000025e0| 75 72 6e 73 20 74 68 65 | 20 72 65 6d 61 69 6e 64 |urns the| remaind|
|000025f0| 65 72 20 61 66 74 65 72 | 20 61 20 6e 75 6d 62 65 |er after| a numbe|
|00002600| 72 20 69 73 20 64 69 76 | 69 64 65 64 20 62 79 20 |r is div|ided by |
|00002610| 61 20 64 69 76 69 73 6f | 72 56 69 73 20 74 68 65 |a diviso|rVis the|
|00002620| 20 6e 75 6d 62 65 72 20 | 66 6f 72 20 77 68 69 63 | number |for whic|
|00002630| 68 20 79 6f 75 20 77 61 | 6e 74 20 74 6f 20 66 69 |h you wa|nt to fi|
|00002640| 6e 64 20 74 68 65 20 72 | 65 6d 61 69 6e 64 65 72 |nd the r|emainder|
|00002650| 20 61 66 74 65 72 20 74 | 68 65 20 64 69 76 69 73 | after t|he divis|
|00002660| 69 6f 6e 20 69 73 20 70 | 65 72 66 6f 72 6d 65 64 |ion is p|erformed|
|00002670| 30 69 73 20 74 68 65 20 | 6e 75 6d 62 65 72 20 62 |0is the |number b|
|00002680| 79 20 77 68 69 63 68 20 | 79 6f 75 20 77 61 6e 74 |y which |you want|
|00002690| 20 74 6f 20 64 69 76 69 | 64 65 20 4e 75 6d 62 65 | to divi|de Numbe|
|000026a0| 72 00 17 64 61 74 61 62 | 61 73 65 2c 66 69 65 6c |r..datab|ase,fiel|
|000026b0| 64 2c 63 72 69 74 65 72 | 69 61 00 7a 43 6f 75 6e |d,criter|ia.zCoun|
|000026c0| 74 73 20 74 68 65 20 63 | 65 6c 6c 73 20 63 6f 6e |ts the c|ells con|
|000026d0| 74 61 69 6e 69 6e 67 20 | 6e 75 6d 62 65 72 73 20 |taining |numbers |
|000026e0| 69 6e 20 74 68 65 20 66 | 69 65 6c 64 20 28 63 6f |in the f|ield (co|
|000026f0| 6c 75 6d 6e 29 20 6f 66 | 20 72 65 63 6f 72 64 73 |lumn) of| records|
|00002700| 20 69 6e 20 74 68 65 20 | 64 61 74 61 62 61 73 65 | in the |database|
|00002710| 20 74 68 61 74 20 6d 61 | 74 63 68 20 74 68 65 20 | that ma|tch the |
|00002720| 63 6f 6e 64 69 74 69 6f | 6e 73 20 79 6f 75 20 73 |conditio|ns you s|
|00002730| 70 65 63 69 66 79 5e 69 | 73 20 74 68 65 20 72 61 |pecify^i|s the ra|
|00002740| 6e 67 65 20 6f 66 20 63 | 65 6c 6c 73 20 74 68 61 |nge of c|ells tha|
|00002750| 74 20 6d 61 6b 65 73 20 | 75 70 20 74 68 65 20 6c |t makes |up the l|
|00002760| 69 73 74 20 6f 72 20 64 | 61 74 61 62 61 73 65 2e |ist or d|atabase.|
|00002770| 20 41 20 64 61 74 61 62 | 61 73 65 20 69 73 20 61 | A datab|ase is a|
|00002780| 20 6c 69 73 74 20 6f 66 | 20 72 65 6c 61 74 65 64 | list of| related|
|00002790| 20 64 61 74 61 79 69 73 | 20 65 69 74 68 65 72 20 | datayis| either |
|000027a0| 74 68 65 20 6c 61 62 65 | 6c 20 6f 66 20 74 68 65 |the labe|l of the|
|000027b0| 20 63 6f 6c 75 6d 6e 20 | 69 6e 20 64 6f 75 62 6c | column |in doubl|
|000027c0| 65 20 71 75 6f 74 61 74 | 69 6f 6e 20 6d 61 72 6b |e quotat|ion mark|
|000027d0| 73 20 6f 72 20 61 20 6e | 75 6d 62 65 72 20 74 68 |s or a n|umber th|
|000027e0| 61 74 20 72 65 70 72 65 | 73 65 6e 74 73 20 74 68 |at repre|sents th|
|000027f0| 65 20 63 6f 6c 75 6d 6e | 27 73 20 70 6f 73 69 74 |e column|'s posit|
|00002800| 69 6f 6e 20 69 6e 20 74 | 68 65 20 6c 69 73 74 8e |ion in t|he list.|
|00002810| 69 73 20 74 68 65 20 72 | 61 6e 67 65 20 6f 66 20 |is the r|ange of |
|00002820| 63 65 6c 6c 73 20 74 68 | 61 74 20 63 6f 6e 74 61 |cells th|at conta|
|00002830| 69 6e 73 20 74 68 65 20 | 63 6f 6e 64 69 74 69 6f |ins the |conditio|
|00002840| 6e 73 20 79 6f 75 20 73 | 70 65 63 69 66 79 2e 20 |ns you s|pecify. |
|00002850| 54 68 65 20 72 61 6e 67 | 65 20 69 6e 63 6c 75 64 |The rang|e includ|
|00002860| 65 73 20 61 20 63 6f 6c | 75 6d 6e 20 6c 61 62 65 |es a col|umn labe|
|00002870| 6c 20 61 6e 64 20 6f 6e | 65 20 63 65 6c 6c 20 62 |l and on|e cell b|
|00002880| 65 6c 6f 77 20 74 68 65 | 20 6c 61 62 65 6c 20 66 |elow the| label f|
|00002890| 6f 72 20 61 20 63 6f 6e | 64 69 74 69 6f 6e 00 17 |or a con|dition..|
|000028a0| 64 61 74 61 62 61 73 65 | 2c 66 69 65 6c 64 2c 63 |database|,field,c|
|000028b0| 72 69 74 65 72 69 61 00 | 67 41 64 64 73 20 74 68 |riteria.|gAdds th|
|000028c0| 65 20 6e 75 6d 62 65 72 | 73 20 69 6e 20 74 68 65 |e number|s in the|
|000028d0| 20 66 69 65 6c 64 20 28 | 63 6f 6c 75 6d 6e 29 20 | field (|column) |
|000028e0| 6f 66 20 72 65 63 6f 72 | 64 73 20 69 6e 20 74 68 |of recor|ds in th|
|000028f0| 65 20 64 61 74 61 62 61 | 73 65 20 74 68 61 74 20 |e databa|se that |
|00002900| 6d 61 74 63 68 20 74 68 | 65 20 63 6f 6e 64 69 74 |match th|e condit|
|00002910| 69 6f 6e 73 20 79 6f 75 | 20 73 70 65 63 69 66 79 |ions you| specify|
|00002920| 5e 69 73 20 74 68 65 20 | 72 61 6e 67 65 20 6f 66 |^is the |range of|
|00002930| 20 63 65 6c 6c 73 20 74 | 68 61 74 20 6d 61 6b 65 | cells t|hat make|
|00002940| 73 20 75 70 20 74 68 65 | 20 6c 69 73 74 20 6f 72 |s up the| list or|
|00002950| 20 64 61 74 61 62 61 73 | 65 2e 20 41 20 64 61 74 | databas|e. A dat|
|00002960| 61 62 61 73 65 20 69 73 | 20 61 20 6c 69 73 74 20 |abase is| a list |
|00002970| 6f 66 20 72 65 6c 61 74 | 65 64 20 64 61 74 61 79 |of relat|ed datay|
|00002980| 69 73 20 65 69 74 68 65 | 72 20 74 68 65 20 6c 61 |is eithe|r the la|
|00002990| 62 65 6c 20 6f 66 20 74 | 68 65 20 63 6f 6c 75 6d |bel of t|he colum|
|000029a0| 6e 20 69 6e 20 64 6f 75 | 62 6c 65 20 71 75 6f 74 |n in dou|ble quot|
|000029b0| 61 74 69 6f 6e 20 6d 61 | 72 6b 73 20 6f 72 20 61 |ation ma|rks or a|
|000029c0| 20 6e 75 6d 62 65 72 20 | 74 68 61 74 20 72 65 70 | number |that rep|
|000029d0| 72 65 73 65 6e 74 73 20 | 74 68 65 20 63 6f 6c 75 |resents |the colu|
|000029e0| 6d 6e 27 73 20 70 6f 73 | 69 74 69 6f 6e 20 69 6e |mn's pos|ition in|
|000029f0| 20 74 68 65 20 6c 69 73 | 74 8e 69 73 20 74 68 65 | the lis|t.is the|
|00002a00| 20 72 61 6e 67 65 20 6f | 66 20 63 65 6c 6c 73 20 | range o|f cells |
|00002a10| 74 68 61 74 20 63 6f 6e | 74 61 69 6e 73 20 74 68 |that con|tains th|
|00002a20| 65 20 63 6f 6e 64 69 74 | 69 6f 6e 73 20 79 6f 75 |e condit|ions you|
|00002a30| 20 73 70 65 63 69 66 79 | 2e 20 54 68 65 20 72 61 | specify|. The ra|
|00002a40| 6e 67 65 20 69 6e 63 6c | 75 64 65 73 20 61 20 63 |nge incl|udes a c|
|00002a50| 6f 6c 75 6d 6e 20 6c 61 | 62 65 6c 20 61 6e 64 20 |olumn la|bel and |
|00002a60| 6f 6e 65 20 63 65 6c 6c | 20 62 65 6c 6f 77 20 74 |one cell| below t|
|00002a70| 68 65 20 6c 61 62 65 6c | 20 66 6f 72 20 61 20 63 |he label| for a c|
|00002a80| 6f 6e 64 69 74 69 6f 6e | 00 17 64 61 74 61 62 61 |ondition|..databa|
|00002a90| 73 65 2c 66 69 65 6c 64 | 2c 63 72 69 74 65 72 69 |se,field|,criteri|
|00002aa0| 61 00 76 41 76 65 72 61 | 67 65 73 20 74 68 65 20 |a.vAvera|ges the |
|00002ab0| 76 61 6c 75 65 73 20 69 | 6e 20 61 20 63 6f 6c 75 |values i|n a colu|
|00002ac0| 6d 6e 20 69 6e 20 61 20 | 6c 69 73 74 20 6f 72 20 |mn in a |list or |
|00002ad0| 64 61 74 61 62 61 73 65 | 20 74 68 61 74 20 6d 61 |database| that ma|
|00002ae0| 74 63 68 20 63 6f 6e 64 | 69 74 69 6f 6e 73 20 79 |tch cond|itions y|
|00002af0| 6f 75 20 73 70 65 63 69 | 66 79 2e 20 46 6f 72 20 |ou speci|fy. For |
|00002b00| 6d 6f 72 65 20 69 6e 66 | 6f 72 6d 61 74 69 6f 6e |more inf|ormation|
|00002b10| 20 73 65 65 20 48 65 6c | 70 5e 69 73 20 74 68 65 | see Hel|p^is the|
|00002b20| 20 72 61 6e 67 65 20 6f | 66 20 63 65 6c 6c 73 20 | range o|f cells |
|00002b30| 74 68 61 74 20 6d 61 6b | 65 73 20 75 70 20 74 68 |that mak|es up th|
|00002b40| 65 20 6c 69 73 74 20 6f | 72 20 64 61 74 61 62 61 |e list o|r databa|
|00002b50| 73 65 2e 20 41 20 64 61 | 74 61 62 61 73 65 20 69 |se. A da|tabase i|
|00002b60| 73 20 61 20 6c 69 73 74 | 20 6f 66 20 72 65 6c 61 |s a list| of rela|
|00002b70| 74 65 64 20 64 61 74 61 | 79 69 73 20 65 69 74 68 |ted data|yis eith|
|00002b80| 65 72 20 74 68 65 20 6c | 61 62 65 6c 20 6f 66 20 |er the l|abel of |
|00002b90| 74 68 65 20 63 6f 6c 75 | 6d 6e 20 69 6e 20 64 6f |the colu|mn in do|
|00002ba0| 75 62 6c 65 20 71 75 6f | 74 61 74 69 6f 6e 20 6d |uble quo|tation m|
|00002bb0| 61 72 6b 73 20 6f 72 20 | 61 20 6e 75 6d 62 65 72 |arks or |a number|
|00002bc0| 20 74 68 61 74 20 72 65 | 70 72 65 73 65 6e 74 73 | that re|presents|
|00002bd0| 20 74 68 65 20 63 6f 6c | 75 6d 6e 27 73 20 70 6f | the col|umn's po|
|00002be0| 73 69 74 69 6f 6e 20 69 | 6e 20 74 68 65 20 6c 69 |sition i|n the li|
|00002bf0| 73 74 8e 69 73 20 74 68 | 65 20 72 61 6e 67 65 20 |st.is th|e range |
|00002c00| 6f 66 20 63 65 6c 6c 73 | 20 74 68 61 74 20 63 6f |of cells| that co|
|00002c10| 6e 74 61 69 6e 73 20 74 | 68 65 20 63 6f 6e 64 69 |ntains t|he condi|
|00002c20| 74 69 6f 6e 73 20 79 6f | 75 20 73 70 65 63 69 66 |tions yo|u specif|
|00002c30| 79 2e 20 54 68 65 20 72 | 61 6e 67 65 20 69 6e 63 |y. The r|ange inc|
|00002c40| 6c 75 64 65 73 20 61 20 | 63 6f 6c 75 6d 6e 20 6c |ludes a |column l|
|00002c50| 61 62 65 6c 20 61 6e 64 | 20 6f 6e 65 20 63 65 6c |abel and| one cel|
|00002c60| 6c 20 62 65 6c 6f 77 20 | 74 68 65 20 6c 61 62 65 |l below |the labe|
|00002c70| 6c 20 66 6f 72 20 61 20 | 63 6f 6e 64 69 74 69 6f |l for a |conditio|
|00002c80| 6e 00 17 64 61 74 61 62 | 61 73 65 2c 66 69 65 6c |n..datab|ase,fiel|
|00002c90| 64 2c 63 72 69 74 65 72 | 69 61 00 72 52 65 74 75 |d,criter|ia.rRetu|
|00002ca0| 72 6e 73 20 74 68 65 20 | 73 6d 61 6c 6c 65 73 74 |rns the |smallest|
|00002cb0| 20 6e 75 6d 62 65 72 20 | 69 6e 20 74 68 65 20 66 | number |in the f|
|00002cc0| 69 65 6c 64 20 28 63 6f | 6c 75 6d 6e 29 20 6f 66 |ield (co|lumn) of|
|00002cd0| 20 72 65 63 6f 72 64 73 | 20 69 6e 20 74 68 65 20 | records| in the |
|00002ce0| 64 61 74 61 62 61 73 65 | 20 74 68 61 74 20 6d 61 |database| that ma|
|00002cf0| 74 63 68 20 74 68 65 20 | 63 6f 6e 64 69 74 69 6f |tch the |conditio|
|00002d00| 6e 73 20 79 6f 75 20 73 | 70 65 63 69 66 79 5e 69 |ns you s|pecify^i|
|00002d10| 73 20 74 68 65 20 72 61 | 6e 67 65 20 6f 66 20 63 |s the ra|nge of c|
|00002d20| 65 6c 6c 73 20 74 68 61 | 74 20 6d 61 6b 65 73 20 |ells tha|t makes |
|00002d30| 75 70 20 74 68 65 20 6c | 69 73 74 20 6f 72 20 64 |up the l|ist or d|
|00002d40| 61 74 61 62 61 73 65 2e | 20 41 20 64 61 74 61 62 |atabase.| A datab|
|00002d50| 61 73 65 20 69 73 20 61 | 20 6c 69 73 74 20 6f 66 |ase is a| list of|
|00002d60| 20 72 65 6c 61 74 65 64 | 20 64 61 74 61 79 69 73 | related| datayis|
|00002d70| 20 65 69 74 68 65 72 20 | 74 68 65 20 6c 61 62 65 | either |the labe|
|00002d80| 6c 20 6f 66 20 74 68 65 | 20 63 6f 6c 75 6d 6e 20 |l of the| column |
|00002d90| 69 6e 20 64 6f 75 62 6c | 65 20 71 75 6f 74 61 74 |in doubl|e quotat|
|00002da0| 69 6f 6e 20 6d 61 72 6b | 73 20 6f 72 20 61 20 6e |ion mark|s or a n|
|00002db0| 75 6d 62 65 72 20 74 68 | 61 74 20 72 65 70 72 65 |umber th|at repre|
|00002dc0| 73 65 6e 74 73 20 74 68 | 65 20 63 6f 6c 75 6d 6e |sents th|e column|
|00002dd0| 27 73 20 70 6f 73 69 74 | 69 6f 6e 20 69 6e 20 74 |'s posit|ion in t|
|00002de0| 68 65 20 6c 69 73 74 8e | 69 73 20 74 68 65 20 72 |he list.|is the r|
|00002df0| 61 6e 67 65 20 6f 66 20 | 63 65 6c 6c 73 20 74 68 |ange of |cells th|
|00002e00| 61 74 20 63 6f 6e 74 61 | 69 6e 73 20 74 68 65 20 |at conta|ins the |
|00002e10| 63 6f 6e 64 69 74 69 6f | 6e 73 20 79 6f 75 20 73 |conditio|ns you s|
|00002e20| 70 65 63 69 66 79 2e 20 | 54 68 65 20 72 61 6e 67 |pecify. |The rang|
|00002e30| 65 20 69 6e 63 6c 75 64 | 65 73 20 61 20 63 6f 6c |e includ|es a col|
|00002e40| 75 6d 6e 20 6c 61 62 65 | 6c 20 61 6e 64 20 6f 6e |umn labe|l and on|
|00002e50| 65 20 63 65 6c 6c 20 62 | 65 6c 6f 77 20 74 68 65 |e cell b|elow the|
|00002e60| 20 6c 61 62 65 6c 20 66 | 6f 72 20 61 20 63 6f 6e | label f|or a con|
|00002e70| 64 69 74 69 6f 6e 00 17 | 64 61 74 61 62 61 73 65 |dition..|database|
|00002e80| 2c 66 69 65 6c 64 2c 63 | 72 69 74 65 72 69 61 00 |,field,c|riteria.|
|00002e90| 72 52 65 74 75 72 6e 73 | 20 74 68 65 20 6c 61 72 |rReturns| the lar|
|00002ea0| 67 65 73 74 20 6e 75 6d | 62 65 72 20 69 6e 20 74 |gest num|ber in t|
|00002eb0| 68 65 20 66 69 65 6c 64 | 20 28 63 6f 6c 75 6d 6e |he field| (column|
|00002ec0| 29 20 6f 66 20 72 65 63 | 6f 72 64 73 20 69 6e 20 |) of rec|ords in |
|00002ed0| 74 68 65 20 64 61 74 61 | 62 61 73 65 20 74 68 61 |the data|base tha|
|00002ee0| 74 20 6d 61 74 63 68 20 | 74 68 65 20 63 6f 6e 64 |t match |the cond|
|00002ef0| 69 74 69 6f 6e 73 20 79 | 6f 75 20 73 70 65 63 69 |itions y|ou speci|
|00002f00| 66 79 2e 5e 69 73 20 74 | 68 65 20 72 61 6e 67 65 |fy.^is t|he range|
|00002f10| 20 6f 66 20 63 65 6c 6c | 73 20 74 68 61 74 20 6d | of cell|s that m|
|00002f20| 61 6b 65 73 20 75 70 20 | 74 68 65 20 6c 69 73 74 |akes up |the list|
|00002f30| 20 6f 72 20 64 61 74 61 | 62 61 73 65 2e 20 41 20 | or data|base. A |
|00002f40| 64 61 74 61 62 61 73 65 | 20 69 73 20 61 20 6c 69 |database| is a li|
|00002f50| 73 74 20 6f 66 20 72 65 | 6c 61 74 65 64 20 64 61 |st of re|lated da|
|00002f60| 74 61 79 69 73 20 65 69 | 74 68 65 72 20 74 68 65 |tayis ei|ther the|
|00002f70| 20 6c 61 62 65 6c 20 6f | 66 20 74 68 65 20 63 6f | label o|f the co|
|00002f80| 6c 75 6d 6e 20 69 6e 20 | 64 6f 75 62 6c 65 20 71 |lumn in |double q|
|00002f90| 75 6f 74 61 74 69 6f 6e | 20 6d 61 72 6b 73 20 6f |uotation| marks o|
|00002fa0| 72 20 61 20 6e 75 6d 62 | 65 72 20 74 68 61 74 20 |r a numb|er that |
|00002fb0| 72 65 70 72 65 73 65 6e | 74 73 20 74 68 65 20 63 |represen|ts the c|
|00002fc0| 6f 6c 75 6d 6e 27 73 20 | 70 6f 73 69 74 69 6f 6e |olumn's |position|
|00002fd0| 20 69 6e 20 74 68 65 20 | 6c 69 73 74 8e 69 73 20 | in the |list.is |
|00002fe0| 74 68 65 20 72 61 6e 67 | 65 20 6f 66 20 63 65 6c |the rang|e of cel|
|00002ff0| 6c 73 20 74 68 61 74 20 | 63 6f 6e 74 61 69 6e 73 |ls that |contains|
|00003000| 20 74 68 65 20 63 6f 6e | 64 69 74 69 6f 6e 73 20 | the con|ditions |
|00003010| 79 6f 75 20 73 70 65 63 | 69 66 79 2e 20 54 68 65 |you spec|ify. The|
|00003020| 20 72 61 6e 67 65 20 69 | 6e 63 6c 75 64 65 73 20 | range i|ncludes |
|00003030| 61 20 63 6f 6c 75 6d 6e | 20 6c 61 62 65 6c 20 61 |a column| label a|
|00003040| 6e 64 20 6f 6e 65 20 63 | 65 6c 6c 20 62 65 6c 6f |nd one c|ell belo|
|00003050| 77 20 74 68 65 20 6c 61 | 62 65 6c 20 66 6f 72 20 |w the la|bel for |
|00003060| 61 20 63 6f 6e 64 69 74 | 69 6f 6e 00 17 64 61 74 |a condit|ion..dat|
|00003070| 61 62 61 73 65 2c 66 69 | 65 6c 64 2c 63 72 69 74 |abase,fi|eld,crit|
|00003080| 65 72 69 61 00 51 45 73 | 74 69 6d 61 74 65 73 20 |eria.QEs|timates |
|00003090| 74 68 65 20 73 74 61 6e | 64 61 72 64 20 64 65 76 |the stan|dard dev|
|000030a0| 69 61 74 69 6f 6e 20 62 | 61 73 65 64 20 6f 6e 20 |iation b|ased on |
|000030b0| 61 20 73 61 6d 70 6c 65 | 20 66 72 6f 6d 20 73 65 |a sample| from se|
|000030c0| 6c 65 63 74 65 64 20 64 | 61 74 61 62 61 73 65 20 |lected d|atabase |
|000030d0| 65 6e 74 72 69 65 73 5e | 69 73 20 74 68 65 20 72 |entries^|is the r|
|000030e0| 61 6e 67 65 20 6f 66 20 | 63 65 6c 6c 73 20 74 68 |ange of |cells th|
|000030f0| 61 74 20 6d 61 6b 65 73 | 20 75 70 20 74 68 65 20 |at makes| up the |
|00003100| 6c 69 73 74 20 6f 72 20 | 64 61 74 61 62 61 73 65 |list or |database|
|00003110| 2e 20 41 20 64 61 74 61 | 62 61 73 65 20 69 73 20 |. A data|base is |
|00003120| 61 20 6c 69 73 74 20 6f | 66 20 72 65 6c 61 74 65 |a list o|f relate|
|00003130| 64 20 64 61 74 61 79 69 | 73 20 65 69 74 68 65 72 |d datayi|s either|
|00003140| 20 74 68 65 20 6c 61 62 | 65 6c 20 6f 66 20 74 68 | the lab|el of th|
|00003150| 65 20 63 6f 6c 75 6d 6e | 20 69 6e 20 64 6f 75 62 |e column| in doub|
|00003160| 6c 65 20 71 75 6f 74 61 | 74 69 6f 6e 20 6d 61 72 |le quota|tion mar|
|00003170| 6b 73 20 6f 72 20 61 20 | 6e 75 6d 62 65 72 20 74 |ks or a |number t|
|00003180| 68 61 74 20 72 65 70 72 | 65 73 65 6e 74 73 20 74 |hat repr|esents t|
|00003190| 68 65 20 63 6f 6c 75 6d | 6e 27 73 20 70 6f 73 69 |he colum|n's posi|
|000031a0| 74 69 6f 6e 20 69 6e 20 | 74 68 65 20 6c 69 73 74 |tion in |the list|
|000031b0| 8e 69 73 20 74 68 65 20 | 72 61 6e 67 65 20 6f 66 |.is the |range of|
|000031c0| 20 63 65 6c 6c 73 20 74 | 68 61 74 20 63 6f 6e 74 | cells t|hat cont|
|000031d0| 61 69 6e 73 20 74 68 65 | 20 63 6f 6e 64 69 74 69 |ains the| conditi|
|000031e0| 6f 6e 73 20 79 6f 75 20 | 73 70 65 63 69 66 79 2e |ons you |specify.|
|000031f0| 20 54 68 65 20 72 61 6e | 67 65 20 69 6e 63 6c 75 | The ran|ge inclu|
|00003200| 64 65 73 20 61 20 63 6f | 6c 75 6d 6e 20 6c 61 62 |des a co|lumn lab|
|00003210| 65 6c 20 61 6e 64 20 6f | 6e 65 20 63 65 6c 6c 20 |el and o|ne cell |
|00003220| 62 65 6c 6f 77 20 74 68 | 65 20 6c 61 62 65 6c 20 |below th|e label |
|00003230| 66 6f 72 20 61 20 63 6f | 6e 64 69 74 69 6f 6e 00 |for a co|ndition.|
|00003240| 13 6e 75 6d 62 65 72 31 | 2c 6e 75 6d 62 65 72 32 |.number1|,number2|
|00003250| 2c 2e 2e 2e 00 54 45 73 | 74 69 6d 61 74 65 73 20 |,....TEs|timates |
|00003260| 76 61 72 69 61 6e 63 65 | 20 62 61 73 65 64 20 6f |variance| based o|
|00003270| 6e 20 61 20 73 61 6d 70 | 6c 65 20 28 69 67 6e 6f |n a samp|le (igno|
|00003280| 72 65 73 20 6c 6f 67 69 | 63 61 6c 20 76 61 6c 75 |res logi|cal valu|
|00003290| 65 73 20 61 6e 64 20 74 | 65 78 74 20 69 6e 20 74 |es and t|ext in t|
|000032a0| 68 65 20 73 61 6d 70 6c | 65 29 47 61 72 65 20 31 |he sampl|e)Gare 1|
|000032b0| 20 74 6f 20 33 30 20 6e | 75 6d 65 72 69 63 20 61 | to 30 n|umeric a|
|000032c0| 72 67 75 6d 65 6e 74 73 | 20 63 6f 72 72 65 73 70 |rguments| corresp|
|000032d0| 6f 6e 64 69 6e 67 20 74 | 6f 20 61 20 73 61 6d 70 |onding t|o a samp|
|000032e0| 6c 65 20 6f 66 20 61 20 | 70 6f 70 75 6c 61 74 69 |le of a |populati|
|000032f0| 6f 6e 00 17 64 61 74 61 | 62 61 73 65 2c 66 69 65 |on..data|base,fie|
|00003300| 6c 64 2c 63 72 69 74 65 | 72 69 61 00 43 45 73 74 |ld,crite|ria.CEst|
|00003310| 69 6d 61 74 65 73 20 76 | 61 72 69 61 6e 63 65 20 |imates v|ariance |
|00003320| 62 61 73 65 64 20 6f 6e | 20 61 20 73 61 6d 70 6c |based on| a sampl|
|00003330| 65 20 66 72 6f 6d 20 73 | 65 6c 65 63 74 65 64 20 |e from s|elected |
|00003340| 64 61 74 61 62 61 73 65 | 20 65 6e 74 72 69 65 73 |database| entries|
|00003350| 5e 69 73 20 74 68 65 20 | 72 61 6e 67 65 20 6f 66 |^is the |range of|
|00003360| 20 63 65 6c 6c 73 20 74 | 68 61 74 20 6d 61 6b 65 | cells t|hat make|
|00003370| 73 20 75 70 20 74 68 65 | 20 6c 69 73 74 20 6f 72 |s up the| list or|
|00003380| 20 64 61 74 61 62 61 73 | 65 2e 20 41 20 64 61 74 | databas|e. A dat|
|00003390| 61 62 61 73 65 20 69 73 | 20 61 20 6c 69 73 74 20 |abase is| a list |
|000033a0| 6f 66 20 72 65 6c 61 74 | 65 64 20 64 61 74 61 79 |of relat|ed datay|
|000033b0| 69 73 20 65 69 74 68 65 | 72 20 74 68 65 20 6c 61 |is eithe|r the la|
|000033c0| 62 65 6c 20 6f 66 20 74 | 68 65 20 63 6f 6c 75 6d |bel of t|he colum|
|000033d0| 6e 20 69 6e 20 64 6f 75 | 62 6c 65 20 71 75 6f 74 |n in dou|ble quot|
|000033e0| 61 74 69 6f 6e 20 6d 61 | 72 6b 73 20 6f 72 20 61 |ation ma|rks or a|
|000033f0| 20 6e 75 6d 62 65 72 20 | 74 68 61 74 20 72 65 70 | number |that rep|
|00003400| 72 65 73 65 6e 74 73 20 | 74 68 65 20 63 6f 6c 75 |resents |the colu|
|00003410| 6d 6e 27 73 20 70 6f 73 | 69 74 69 6f 6e 20 69 6e |mn's pos|ition in|
|00003420| 20 74 68 65 20 6c 69 73 | 74 8e 69 73 20 74 68 65 | the lis|t.is the|
|00003430| 20 72 61 6e 67 65 20 6f | 66 20 63 65 6c 6c 73 20 | range o|f cells |
|00003440| 74 68 61 74 20 63 6f 6e | 74 61 69 6e 73 20 74 68 |that con|tains th|
|00003450| 65 20 63 6f 6e 64 69 74 | 69 6f 6e 73 20 79 6f 75 |e condit|ions you|
|00003460| 20 73 70 65 63 69 66 79 | 2e 20 54 68 65 20 72 61 | specify|. The ra|
|00003470| 6e 67 65 20 69 6e 63 6c | 75 64 65 73 20 61 20 63 |nge incl|udes a c|
|00003480| 6f 6c 75 6d 6e 20 6c 61 | 62 65 6c 20 61 6e 64 20 |olumn la|bel and |
|00003490| 6f 6e 65 20 63 65 6c 6c | 20 62 65 6c 6f 77 20 74 |one cell| below t|
|000034a0| 68 65 20 6c 61 62 65 6c | 20 66 6f 72 20 61 20 63 |he label| for a c|
|000034b0| 6f 6e 64 69 74 69 6f 6e | 00 11 76 61 6c 75 65 2c |ondition|..value,|
|000034c0| 66 6f 72 6d 61 74 5f 74 | 65 78 74 00 34 43 6f 6e |format_t|ext.4Con|
|000034d0| 76 65 72 74 73 20 61 20 | 76 61 6c 75 65 20 74 6f |verts a |value to|
|000034e0| 20 74 65 78 74 20 69 6e | 20 61 20 73 70 65 63 69 | text in| a speci|
|000034f0| 66 69 63 20 6e 75 6d 62 | 65 72 20 66 6f 72 6d 61 |fic numb|er forma|
|00003500| 74 6d 69 73 20 61 20 6e | 75 6d 62 65 72 2c 20 61 |tmis a n|umber, a|
|00003510| 20 66 6f 72 6d 75 6c 61 | 20 74 68 61 74 20 65 76 | formula| that ev|
|00003520| 61 6c 75 61 74 65 73 20 | 74 6f 20 61 20 6e 75 6d |aluates |to a num|
|00003530| 65 72 69 63 20 76 61 6c | 75 65 2c 20 6f 72 20 61 |eric val|ue, or a|
|00003540| 20 72 65 66 65 72 65 6e | 63 65 20 74 6f 20 61 20 | referen|ce to a |
|00003550| 63 65 6c 6c 20 63 6f 6e | 74 61 69 6e 69 6e 67 20 |cell con|taining |
|00003560| 61 20 6e 75 6d 65 72 69 | 63 20 76 61 6c 75 65 74 |a numeri|c valuet|
|00003570| 69 73 20 61 20 6e 75 6d | 62 65 72 20 66 6f 72 6d |is a num|ber form|
|00003580| 61 74 20 69 6e 20 74 65 | 78 74 20 66 6f 72 6d 20 |at in te|xt form |
|00003590| 66 72 6f 6d 20 74 68 65 | 20 43 61 74 65 67 6f 72 |from the| Categor|
|000035a0| 79 20 62 6f 78 20 6f 6e | 20 74 68 65 20 4e 75 6d |y box on| the Num|
|000035b0| 62 65 72 20 74 61 62 20 | 69 6e 20 74 68 65 20 46 |ber tab |in the F|
|000035c0| 6f 72 6d 61 74 20 43 65 | 6c 6c 73 20 64 69 61 6c |ormat Ce|lls dial|
|000035d0| 6f 67 20 62 6f 78 20 28 | 6e 6f 74 20 47 65 6e 65 |og box (|not Gene|
|000035e0| 72 61 6c 29 00 1f 6b 6e | 6f 77 6e 5f 79 27 73 2c |ral)..kn|own_y's,|
|000035f0| 6b 6e 6f 77 6e 5f 78 27 | 73 2c 63 6f 6e 73 74 2c |known_x'|s,const,|
|00003600| 73 74 61 74 73 00 76 52 | 65 74 75 72 6e 73 20 61 |stats.vR|eturns a|
|00003610| 6e 20 61 72 72 61 79 20 | 74 68 61 74 20 64 65 73 |n array |that des|
|00003620| 63 72 69 62 65 73 20 61 | 20 73 74 72 61 69 67 68 |cribes a| straigh|
|00003630| 74 20 6c 69 6e 65 20 74 | 68 61 74 20 62 65 73 74 |t line t|hat best|
|00003640| 20 66 69 74 73 20 79 6f | 75 72 20 64 61 74 61 2c | fits yo|ur data,|
|00003650| 20 63 61 6c 63 75 6c 61 | 74 65 64 20 62 79 20 75 | calcula|ted by u|
|00003660| 73 69 6e 67 20 74 68 65 | 20 6c 65 61 73 74 20 73 |sing the| least s|
|00003670| 71 75 61 72 65 73 20 6d | 65 74 68 6f 64 46 69 73 |quares m|ethodFis|
|00003680| 20 74 68 65 20 73 65 74 | 20 6f 66 20 79 2d 76 61 | the set| of y-va|
|00003690| 6c 75 65 73 20 79 6f 75 | 20 61 6c 72 65 61 64 79 |lues you| already|
|000036a0| 20 6b 6e 6f 77 20 69 6e | 20 74 68 65 20 72 65 6c | know in| the rel|
|000036b0| 61 74 69 6f 6e 73 68 69 | 70 20 79 20 3d 20 6d 78 |ationshi|p y = mx|
|000036c0| 20 2b 20 62 57 69 73 20 | 61 6e 20 6f 70 74 69 6f | + bWis |an optio|
|000036d0| 6e 61 6c 20 73 65 74 20 | 6f 66 20 78 2d 76 61 6c |nal set |of x-val|
|000036e0| 75 65 73 20 74 68 61 74 | 20 79 6f 75 20 6d 61 79 |ues that| you may|
|000036f0| 20 61 6c 72 65 61 64 79 | 20 6b 6e 6f 77 20 69 6e | already| know in|
|00003700| 20 74 68 65 20 72 65 6c | 61 74 69 6f 6e 73 68 69 | the rel|ationshi|
|00003710| 70 20 79 20 3d 20 6d 78 | 20 2b 20 62 7a 69 73 20 |p y = mx| + bzis |
|00003720| 61 20 6c 6f 67 69 63 61 | 6c 20 76 61 6c 75 65 3a |a logica|l value:|
|00003730| 20 74 68 65 20 63 6f 6e | 73 74 61 6e 74 20 62 20 | the con|stant b |
|00003740| 69 73 20 63 61 6c 63 75 | 6c 61 74 65 64 20 6e 6f |is calcu|lated no|
|00003750| 72 6d 61 6c 6c 79 20 69 | 66 20 43 6f 6e 73 74 20 |rmally i|f Const |
|00003760| 3d 20 54 52 55 45 20 6f | 72 20 6f 6d 69 74 74 65 |= TRUE o|r omitte|
|00003770| 64 3b 20 62 20 69 73 20 | 73 65 74 20 65 71 75 61 |d; b is |set equa|
|00003780| 6c 20 74 6f 20 30 20 69 | 66 20 43 6f 6e 73 74 20 |l to 0 i|f Const |
|00003790| 3d 20 46 41 4c 53 45 7f | 69 73 20 61 20 6c 6f 67 |= FALSE.|is a log|
|000037a0| 69 63 61 6c 20 76 61 6c | 75 65 3a 20 72 65 74 75 |ical val|ue: retu|
|000037b0| 72 6e 20 61 64 64 69 74 | 69 6f 6e 61 6c 20 72 65 |rn addit|ional re|
|000037c0| 67 72 65 73 73 69 6f 6e | 20 73 74 61 74 69 73 74 |gression| statist|
|000037d0| 69 63 73 20 3d 20 54 52 | 55 45 3b 20 72 65 74 75 |ics = TR|UE; retu|
|000037e0| 72 6e 20 6d 2d 63 6f 65 | 66 66 69 63 69 65 6e 74 |rn m-coe|fficient|
|000037f0| 73 20 61 6e 64 20 74 68 | 65 20 63 6f 6e 73 74 61 |s and th|e consta|
|00003800| 6e 74 20 62 20 3d 20 46 | 41 4c 53 45 20 6f 72 20 |nt b = F|ALSE or |
|00003810| 6f 6d 69 74 74 65 64 00 | 21 6b 6e 6f 77 6e 5f 79 |omitted.|!known_y|
|00003820| 27 73 2c 6b 6e 6f 77 6e | 5f 78 27 73 2c 6e 65 77 |'s,known|_x's,new|
|00003830| 5f 78 27 73 2c 63 6f 6e | 73 74 00 71 52 65 74 75 |_x's,con|st.qRetu|
|00003840| 72 6e 73 20 76 61 6c 75 | 65 73 20 61 6c 6f 6e 67 |rns valu|es along|
|00003850| 20 61 20 6c 69 6e 65 61 | 72 20 74 72 65 6e 64 20 | a linea|r trend |
|00003860| 62 79 20 66 69 74 74 69 | 6e 67 20 61 20 73 74 72 |by fitti|ng a str|
|00003870| 61 69 67 68 74 20 6c 69 | 6e 65 20 75 73 69 6e 67 |aight li|ne using|
|00003880| 20 74 68 65 20 6c 65 61 | 73 74 20 73 71 75 61 72 | the lea|st squar|
|00003890| 65 73 20 6d 65 74 68 6f | 64 20 74 6f 20 74 68 65 |es metho|d to the|
|000038a0| 20 6b 6e 6f 77 6e 20 76 | 61 6c 75 65 73 4f 69 73 | known v|aluesOis|
|000038b0| 20 61 20 72 61 6e 67 65 | 20 6f 72 20 61 72 72 61 | a range| or arra|
|000038c0| 79 20 6f 66 20 79 2d 76 | 61 6c 75 65 73 20 79 6f |y of y-v|alues yo|
|000038d0| 75 20 61 6c 72 65 61 64 | 79 20 6b 6e 6f 77 20 69 |u alread|y know i|
|000038e0| 6e 20 74 68 65 20 72 65 | 6c 61 74 69 6f 6e 73 68 |n the re|lationsh|
|000038f0| 69 70 20 79 20 3d 20 6d | 78 20 2b 20 62 7b 69 73 |ip y = m|x + b{is|
|00003900| 20 61 6e 20 6f 70 74 69 | 6f 6e 61 6c 20 72 61 6e | an opti|onal ran|
|00003910| 67 65 20 6f 72 20 61 72 | 72 61 79 20 6f 66 20 78 |ge or ar|ray of x|
|00003920| 2d 76 61 6c 75 65 73 20 | 74 68 61 74 20 79 6f 75 |-values |that you|
|00003930| 20 6b 6e 6f 77 20 69 6e | 20 74 68 65 20 72 65 6c | know in| the rel|
|00003940| 61 74 69 6f 6e 73 68 69 | 70 20 79 20 3d 20 6d 78 |ationshi|p y = mx|
|00003950| 20 2b 20 62 2c 20 61 6e | 20 61 72 72 61 79 20 74 | + b, an| array t|
|00003960| 68 65 20 73 61 6d 65 20 | 73 69 7a 65 20 61 73 20 |he same |size as |
|00003970| 4b 6e 6f 77 6e 5f 79 27 | 73 5d 69 73 20 61 20 72 |Known_y'|s]is a r|
|00003980| 61 6e 67 65 20 6f 72 20 | 61 72 72 61 79 20 6f 66 |ange or |array of|
|00003990| 20 6e 65 77 20 78 2d 76 | 61 6c 75 65 73 20 66 6f | new x-v|alues fo|
|000039a0| 72 20 77 68 69 63 68 20 | 79 6f 75 20 77 61 6e 74 |r which |you want|
|000039b0| 20 54 52 45 4e 44 20 74 | 6f 20 72 65 74 75 72 6e | TREND t|o return|
|000039c0| 20 63 6f 72 72 65 73 70 | 6f 6e 64 69 6e 67 20 79 | corresp|onding y|
|000039d0| 2d 76 61 6c 75 65 73 7a | 69 73 20 61 20 6c 6f 67 |-valuesz|is a log|
|000039e0| 69 63 61 6c 20 76 61 6c | 75 65 3a 20 74 68 65 20 |ical val|ue: the |
|000039f0| 63 6f 6e 73 74 61 6e 74 | 20 62 20 69 73 20 63 61 |constant| b is ca|
|00003a00| 6c 63 75 6c 61 74 65 64 | 20 6e 6f 72 6d 61 6c 6c |lculated| normall|
|00003a10| 79 20 69 66 20 43 6f 6e | 73 74 20 3d 20 54 52 55 |y if Con|st = TRU|
|00003a20| 45 20 6f 72 20 6f 6d 69 | 74 74 65 64 3b 20 62 20 |E or omi|tted; b |
|00003a30| 69 73 20 73 65 74 20 65 | 71 75 61 6c 20 74 6f 20 |is set e|qual to |
|00003a40| 30 20 69 66 20 43 6f 6e | 73 74 20 3d 20 46 41 4c |0 if Con|st = FAL|
|00003a50| 53 45 00 1f 6b 6e 6f 77 | 6e 5f 79 27 73 2c 6b 6e |SE..know|n_y's,kn|
|00003a60| 6f 77 6e 5f 78 27 73 2c | 63 6f 6e 73 74 2c 73 74 |own_x's,|const,st|
|00003a70| 61 74 73 00 71 52 65 74 | 75 72 6e 73 20 61 6e 20 |ats.qRet|urns an |
|00003a80| 61 72 72 61 79 20 6f 66 | 20 76 61 6c 75 65 73 20 |array of| values |
|00003a90| 74 68 61 74 20 64 65 73 | 63 72 69 62 65 73 20 61 |that des|cribes a|
|00003aa0| 6e 20 65 78 70 6f 6e 65 | 6e 74 69 61 6c 20 63 75 |n expone|ntial cu|
|00003ab0| 72 76 65 20 63 61 6c 63 | 75 6c 61 74 65 64 20 69 |rve calc|ulated i|
|00003ac0| 6e 20 72 65 67 72 65 73 | 73 69 6f 6e 20 61 6e 61 |n regres|sion ana|
|00003ad0| 6c 79 73 69 73 20 74 6f | 20 66 69 74 20 79 6f 75 |lysis to| fit you|
|00003ae0| 72 20 64 61 74 61 45 69 | 73 20 74 68 65 20 73 65 |r dataEi|s the se|
|00003af0| 74 20 6f 66 20 79 2d 76 | 61 6c 75 65 73 20 79 6f |t of y-v|alues yo|
|00003b00| 75 20 61 6c 72 65 61 64 | 79 20 6b 6e 6f 77 20 69 |u alread|y know i|
|00003b10| 6e 20 74 68 65 20 72 65 | 6c 61 74 69 6f 6e 73 68 |n the re|lationsh|
|00003b20| 69 70 20 79 20 3d 20 62 | 2a 6d 5e 78 56 69 73 20 |ip y = b|*m^xVis |
|00003b30| 61 6e 20 6f 70 74 69 6f | 6e 61 6c 20 73 65 74 20 |an optio|nal set |
|00003b40| 6f 66 20 78 2d 76 61 6c | 75 65 73 20 74 68 61 74 |of x-val|ues that|
|00003b50| 20 79 6f 75 20 6d 61 79 | 20 61 6c 72 65 61 64 79 | you may| already|
|00003b60| 20 6b 6e 6f 77 20 69 6e | 20 74 68 65 20 72 65 6c | know in| the rel|
|00003b70| 61 74 69 6f 6e 73 68 69 | 70 20 79 20 3d 20 62 2a |ationshi|p y = b*|
|00003b80| 6d 5e 78 7a 69 73 20 61 | 20 6c 6f 67 69 63 61 6c |m^xzis a| logical|
|00003b90| 20 76 61 6c 75 65 3a 20 | 74 68 65 20 63 6f 6e 73 | value: |the cons|
|00003ba0| 74 61 6e 74 20 62 20 69 | 73 20 63 61 6c 63 75 6c |tant b i|s calcul|
|00003bb0| 61 74 65 64 20 6e 6f 72 | 6d 61 6c 6c 79 20 69 66 |ated nor|mally if|
|00003bc0| 20 43 6f 6e 73 74 20 3d | 20 54 52 55 45 20 6f 72 | Const =| TRUE or|
|00003bd0| 20 6f 6d 69 74 74 65 64 | 3b 20 62 20 69 73 20 73 | omitted|; b is s|
|00003be0| 65 74 20 65 71 75 61 6c | 20 74 6f 20 31 20 69 66 |et equal| to 1 if|
|00003bf0| 20 43 6f 6e 73 74 20 3d | 20 46 41 4c 53 45 7f 69 | Const =| FALSE.i|
|00003c00| 73 20 61 20 6c 6f 67 69 | 63 61 6c 20 76 61 6c 75 |s a logi|cal valu|
|00003c10| 65 3a 20 72 65 74 75 72 | 6e 20 61 64 64 69 74 69 |e: retur|n additi|
|00003c20| 6f 6e 61 6c 20 72 65 67 | 72 65 73 73 69 6f 6e 20 |onal reg|ression |
|00003c30| 73 74 61 74 69 73 74 69 | 63 73 20 3d 20 54 52 55 |statisti|cs = TRU|
|00003c40| 45 3b 20 72 65 74 75 72 | 6e 20 6d 2d 63 6f 65 66 |E; retur|n m-coef|
|00003c50| 66 69 63 69 65 6e 74 73 | 20 61 6e 64 20 74 68 65 |ficients| and the|
|00003c60| 20 63 6f 6e 73 74 61 6e | 74 20 62 20 3d 20 46 41 | constan|t b = FA|
|00003c70| 4c 53 45 20 6f 72 20 6f | 6d 69 74 74 65 64 00 21 |LSE or o|mitted.!|
|00003c80| 6b 6e 6f 77 6e 5f 79 27 | 73 2c 6b 6e 6f 77 6e 5f |known_y'|s,known_|
|00003c90| 78 27 73 2c 6e 65 77 5f | 78 27 73 2c 63 6f 6e 73 |x's,new_|x's,cons|
|00003ca0| 74 00 7f 43 61 6c 63 75 | 6c 61 74 65 73 20 70 72 |t..Calcu|lates pr|
|00003cb0| 65 64 69 63 74 65 64 20 | 65 78 70 6f 6e 65 6e 74 |edicted |exponent|
|00003cc0| 69 61 6c 20 67 72 6f 77 | 74 68 20 62 79 20 75 73 |ial grow|th by us|
|00003cd0| 69 6e 67 20 65 78 69 73 | 74 69 6e 67 20 64 61 74 |ing exis|ting dat|
|00003ce0| 61 2c 20 72 65 74 75 72 | 6e 69 6e 67 20 74 68 65 |a, retur|ning the|
|00003cf0| 20 79 2d 76 61 6c 75 65 | 73 20 66 6f 72 20 61 20 | y-value|s for a |
|00003d00| 73 65 72 69 65 73 20 6f | 66 20 6e 65 77 20 78 2d |series o|f new x-|
|00003d10| 76 61 6c 75 65 73 20 79 | 6f 75 20 73 70 65 63 69 |values y|ou speci|
|00003d20| 66 79 6c 69 73 20 74 68 | 65 20 73 65 74 20 6f 66 |fylis th|e set of|
|00003d30| 20 79 2d 76 61 6c 75 65 | 73 20 79 6f 75 20 61 6c | y-value|s you al|
|00003d40| 72 65 61 64 79 20 6b 6e | 6f 77 20 69 6e 20 74 68 |ready kn|ow in th|
|00003d50| 65 20 72 65 6c 61 74 69 | 6f 6e 73 68 69 70 20 79 |e relati|onship y|
|00003d60| 20 3d 20 62 2a 6d 5e 78 | 2c 20 61 6e 20 61 72 72 | = b*m^x|, an arr|
|00003d70| 61 79 20 6f 72 20 72 61 | 6e 67 65 20 6f 66 20 70 |ay or ra|nge of p|
|00003d80| 6f 73 69 74 69 76 65 20 | 6e 75 6d 62 65 72 73 84 |ositive |numbers.|
|00003d90| 69 73 20 61 6e 20 6f 70 | 74 69 6f 6e 61 6c 20 73 |is an op|tional s|
|00003da0| 65 74 20 6f 66 20 78 2d | 76 61 6c 75 65 73 20 74 |et of x-|values t|
|00003db0| 68 61 74 20 79 6f 75 20 | 6d 61 79 20 61 6c 72 65 |hat you |may alre|
|00003dc0| 61 64 79 20 6b 6e 6f 77 | 20 69 6e 20 74 68 65 20 |ady know| in the |
|00003dd0| 72 65 6c 61 74 69 6f 6e | 73 68 69 70 20 79 20 3d |relation|ship y =|
|00003de0| 20 62 2a 6d 5e 78 2c 20 | 61 6e 20 61 72 72 61 79 | b*m^x, |an array|
|00003df0| 20 6f 72 20 72 61 6e 67 | 65 20 74 68 65 20 73 61 | or rang|e the sa|
|00003e00| 6d 65 20 73 69 7a 65 20 | 61 73 20 4b 6e 6f 77 6e |me size |as Known|
|00003e10| 5f 79 27 73 4b 61 72 65 | 20 6e 65 77 20 78 2d 76 |_y'sKare| new x-v|
|00003e20| 61 6c 75 65 73 20 66 6f | 72 20 77 68 69 63 68 20 |alues fo|r which |
|00003e30| 79 6f 75 20 77 61 6e 74 | 20 47 52 4f 57 54 48 20 |you want| GROWTH |
|00003e40| 74 6f 20 72 65 74 75 72 | 6e 20 63 6f 72 72 65 73 |to retur|n corres|
|00003e50| 70 6f 6e 64 69 6e 67 20 | 79 2d 76 61 6c 75 65 73 |ponding |y-values|
|00003e60| 7a 69 73 20 61 20 6c 6f | 67 69 63 61 6c 20 76 61 |zis a lo|gical va|
|00003e70| 6c 75 65 3a 20 74 68 65 | 20 63 6f 6e 73 74 61 6e |lue: the| constan|
|00003e80| 74 20 62 20 69 73 20 63 | 61 6c 63 75 6c 61 74 65 |t b is c|alculate|
|00003e90| 64 20 6e 6f 72 6d 61 6c | 6c 79 20 69 66 20 43 6f |d normal|ly if Co|
|00003ea0| 6e 73 74 20 3d 20 54 52 | 55 45 3b 20 62 20 69 73 |nst = TR|UE; b is|
|00003eb0| 20 73 65 74 20 65 71 75 | 61 6c 20 74 6f 20 31 20 | set equ|al to 1 |
|00003ec0| 69 66 20 43 6f 6e 73 74 | 20 3d 20 46 41 4c 53 45 |if Const| = FALSE|
|00003ed0| 20 6f 72 20 6f 6d 69 74 | 74 65 64 00 09 72 65 66 | or omit|ted..ref|
|00003ee0| 65 72 65 6e 63 65 00 00 | 0c 63 61 6e 63 65 6c 5f |erence..|.cancel_|
|00003ef0| 63 6c 6f 73 65 00 00 05 | 76 61 6c 75 65 00 00 15 |close...|value...|
|00003f00| 72 61 74 65 2c 6e 70 65 | 72 2c 70 6d 74 2c 66 76 |rate,npe|r,pmt,fv|
|00003f10| 2c 74 79 70 65 00 6a 52 | 65 74 75 72 6e 73 20 74 |,type.jR|eturns t|
|00003f20| 68 65 20 70 72 65 73 65 | 6e 74 20 76 61 6c 75 65 |he prese|nt value|
|00003f30| 20 6f 66 20 61 6e 20 69 | 6e 76 65 73 74 6d 65 6e | of an i|nvestmen|
|00003f40| 74 3a 20 74 68 65 20 74 | 6f 74 61 6c 20 61 6d 6f |t: the t|otal amo|
|00003f50| 75 6e 74 20 74 68 61 74 | 20 61 20 73 65 72 69 65 |unt that| a serie|
|00003f60| 73 20 6f 66 20 66 75 74 | 75 72 65 20 70 61 79 6d |s of fut|ure paym|
|00003f70| 65 6e 74 73 20 69 73 20 | 77 6f 72 74 68 20 6e 6f |ents is |worth no|
|00003f80| 77 1f 69 73 20 74 68 65 | 20 69 6e 74 65 72 65 73 |w.is the| interes|
|00003f90| 74 20 72 61 74 65 20 70 | 65 72 20 70 65 72 69 6f |t rate p|er perio|
|00003fa0| 64 34 69 73 20 74 68 65 | 20 74 6f 74 61 6c 20 6e |d4is the| total n|
|00003fb0| 75 6d 62 65 72 20 6f 66 | 20 70 61 79 6d 65 6e 74 |umber of| payment|
|00003fc0| 20 70 65 72 69 6f 64 73 | 20 69 6e 20 61 6e 20 61 | periods| in an a|
|00003fd0| 6e 6e 75 69 74 79 4e 69 | 73 20 74 68 65 20 70 61 |nnuityNi|s the pa|
|00003fe0| 79 6d 65 6e 74 20 6d 61 | 64 65 20 65 61 63 68 20 |yment ma|de each |
|00003ff0| 70 65 72 69 6f 64 20 61 | 6e 64 20 63 61 6e 6e 6f |period a|nd canno|
|00004000| 74 20 63 68 61 6e 67 65 | 20 6f 76 65 72 20 74 68 |t change| over th|
|00004010| 65 20 6c 69 66 65 20 6f | 66 20 74 68 65 20 61 6e |e life o|f the an|
|00004020| 6e 75 69 74 79 58 69 73 | 20 74 68 65 20 66 75 74 |nuityXis| the fut|
|00004030| 75 72 65 20 76 61 6c 75 | 65 2c 20 6f 72 20 61 20 |ure valu|e, or a |
|00004040| 63 61 73 68 20 62 61 6c | 61 6e 63 65 20 79 6f 75 |cash bal|ance you|
|00004050| 20 77 61 6e 74 20 74 6f | 20 61 74 74 61 69 6e 20 | want to| attain |
|00004060| 61 66 74 65 72 20 74 68 | 65 20 6c 61 73 74 20 70 |after th|e last p|
|00004070| 61 79 6d 65 6e 74 20 69 | 73 20 6d 61 64 65 6f 69 |ayment i|s madeoi|
|00004080| 73 20 61 20 6c 6f 67 69 | 63 61 6c 20 76 61 6c 75 |s a logi|cal valu|
|00004090| 65 3a 20 70 61 79 6d 65 | 6e 74 20 61 74 20 74 68 |e: payme|nt at th|
|000040a0| 65 20 62 65 67 69 6e 6e | 69 6e 67 20 6f 66 20 74 |e beginn|ing of t|
|000040b0| 68 65 20 70 65 72 69 6f | 64 20 3d 20 31 3b 20 70 |he perio|d = 1; p|
|000040c0| 61 79 6d 65 6e 74 20 61 | 74 20 74 68 65 20 65 6e |ayment a|t the en|
|000040d0| 64 20 6f 66 20 74 68 65 | 20 70 65 72 69 6f 64 20 |d of the| period |
|000040e0| 3d 20 30 20 6f 72 20 6f | 6d 69 74 74 65 64 00 15 |= 0 or o|mitted..|
|000040f0| 72 61 74 65 2c 6e 70 65 | 72 2c 70 6d 74 2c 70 76 |rate,npe|r,pmt,pv|
|00004100| 2c 74 79 70 65 00 6c 52 | 65 74 75 72 6e 73 20 74 |,type.lR|eturns t|
|00004110| 68 65 20 66 75 74 75 72 | 65 20 76 61 6c 75 65 20 |he futur|e value |
|00004120| 6f 66 20 61 6e 20 69 6e | 76 65 73 74 6d 65 6e 74 |of an in|vestment|
|00004130| 20 62 61 73 65 64 20 6f | 6e 20 70 65 72 69 6f 64 | based o|n period|
|00004140| 69 63 2c 20 63 6f 6e 73 | 74 61 6e 74 20 70 61 79 |ic, cons|tant pay|
|00004150| 6d 65 6e 74 73 20 61 6e | 64 20 61 20 63 6f 6e 73 |ments an|d a cons|
|00004160| 74 61 6e 74 20 69 6e 74 | 65 72 65 73 74 20 72 61 |tant int|erest ra|
|00004170| 74 65 2e 1f 69 73 20 74 | 68 65 20 69 6e 74 65 72 |te..is t|he inter|
|00004180| 65 73 74 20 72 61 74 65 | 20 70 65 72 20 70 65 72 |est rate| per per|
|00004190| 69 6f 64 34 69 73 20 74 | 68 65 20 74 6f 74 61 6c |iod4is t|he total|
|000041a0| 20 6e 75 6d 62 65 72 20 | 6f 66 20 70 61 79 6d 65 | number |of payme|
|000041b0| 6e 74 20 70 65 72 69 6f | 64 73 20 69 6e 20 61 6e |nt perio|ds in an|
|000041c0| 20 61 6e 6e 75 69 74 79 | 4e 69 73 20 74 68 65 20 | annuity|Nis the |
|000041d0| 70 61 79 6d 65 6e 74 20 | 6d 61 64 65 20 65 61 63 |payment |made eac|
|000041e0| 68 20 70 65 72 69 6f 64 | 3b 20 69 74 20 63 61 6e |h period|; it can|
|000041f0| 6e 6f 74 20 63 68 61 6e | 67 65 20 6f 76 65 72 20 |not chan|ge over |
|00004200| 74 68 65 20 6c 69 66 65 | 20 6f 66 20 74 68 65 20 |the life| of the |
|00004210| 61 6e 6e 75 69 74 79 6e | 69 73 20 74 68 65 20 70 |annuityn|is the p|
|00004220| 72 65 73 65 6e 74 20 76 | 61 6c 75 65 2c 20 6f 72 |resent v|alue, or|
|00004230| 20 74 68 65 20 6c 75 6d | 70 2d 73 75 6d 20 61 6d | the lum|p-sum am|
|00004240| 6f 75 6e 74 20 74 68 61 | 74 20 61 20 73 65 72 69 |ount tha|t a seri|
|00004250| 65 73 20 6f 66 20 66 75 | 74 75 72 65 20 70 61 79 |es of fu|ture pay|
|00004260| 6d 65 6e 74 73 20 69 73 | 20 77 6f 72 74 68 20 6e |ments is| worth n|
|00004270| 6f 77 2e 20 49 66 20 6f | 6d 69 74 74 65 64 2c 20 |ow. If o|mitted, |
|00004280| 50 76 20 3d 20 30 8a 69 | 73 20 61 20 76 61 6c 75 |Pv = 0.i|s a valu|
|00004290| 65 20 72 65 70 72 65 73 | 65 6e 74 69 6e 67 20 74 |e repres|enting t|
|000042a0| 68 65 20 74 69 6d 69 6e | 67 20 6f 66 20 70 61 79 |he timin|g of pay|
|000042b0| 6d 65 6e 74 3a 20 70 61 | 79 6d 65 6e 74 20 61 74 |ment: pa|yment at|
|000042c0| 20 74 68 65 20 62 65 67 | 69 6e 6e 69 6e 67 20 6f | the beg|inning o|
|000042d0| 66 20 74 68 65 20 70 65 | 72 69 6f 64 20 3d 20 31 |f the pe|riod = 1|
|000042e0| 3b 20 70 61 79 6d 65 6e | 74 20 61 74 20 74 68 65 |; paymen|t at the|
|000042f0| 20 65 6e 64 20 6f 66 20 | 74 68 65 20 70 65 72 69 | end of |the peri|
|00004300| 6f 64 20 3d 20 30 20 6f | 72 20 6f 6d 69 74 74 65 |od = 0 o|r omitte|
|00004310| 64 00 13 72 61 74 65 2c | 70 6d 74 2c 70 76 2c 66 |d..rate,|pmt,pv,f|
|00004320| 76 2c 74 79 70 65 00 71 | 52 65 74 75 72 6e 73 20 |v,type.q|Returns |
|00004330| 74 68 65 20 6e 75 6d 62 | 65 72 20 6f 66 20 70 65 |the numb|er of pe|
|00004340| 72 69 6f 64 73 20 66 6f | 72 20 61 6e 20 69 6e 76 |riods fo|r an inv|
|00004350| 65 73 74 6d 65 6e 74 20 | 62 61 73 65 64 20 6f 6e |estment |based on|
|00004360| 20 70 65 72 69 6f 64 69 | 63 2c 20 63 6f 6e 73 74 | periodi|c, const|
|00004370| 61 6e 74 20 70 61 79 6d | 65 6e 74 73 20 61 6e 64 |ant paym|ents and|
|00004380| 20 61 20 63 6f 6e 73 74 | 61 6e 74 20 69 6e 74 65 | a const|ant inte|
|00004390| 72 65 73 74 20 72 61 74 | 65 1f 69 73 20 74 68 65 |rest rat|e.is the|
|000043a0| 20 69 6e 74 65 72 65 73 | 74 20 72 61 74 65 20 70 | interes|t rate p|
|000043b0| 65 72 20 70 65 72 69 6f | 64 4e 69 73 20 74 68 65 |er perio|dNis the|
|000043c0| 20 70 61 79 6d 65 6e 74 | 20 6d 61 64 65 20 65 61 | payment| made ea|
|000043d0| 63 68 20 70 65 72 69 6f | 64 3b 20 69 74 20 63 61 |ch perio|d; it ca|
|000043e0| 6e 6e 6f 74 20 63 68 61 | 6e 67 65 20 6f 76 65 72 |nnot cha|nge over|
|000043f0| 20 74 68 65 20 6c 69 66 | 65 20 6f 66 20 74 68 65 | the lif|e of the|
|00004400| 20 61 6e 6e 75 69 74 79 | 5a 69 73 20 74 68 65 20 | annuity|Zis the |
|00004410| 70 72 65 73 65 6e 74 20 | 76 61 6c 75 65 2c 20 6f |present |value, o|
|00004420| 72 20 74 68 65 20 6c 75 | 6d 70 2d 73 75 6d 20 61 |r the lu|mp-sum a|
|00004430| 6d 6f 75 6e 74 20 74 68 | 61 74 20 61 20 73 65 72 |mount th|at a ser|
|00004440| 69 65 73 20 6f 66 20 66 | 75 74 75 72 65 20 70 61 |ies of f|uture pa|
|00004450| 79 6d 65 6e 74 73 20 69 | 73 20 77 6f 72 74 68 20 |yments i|s worth |
|00004460| 6e 6f 77 72 69 73 20 74 | 68 65 20 66 75 74 75 72 |nowris t|he futur|
|00004470| 65 20 76 61 6c 75 65 2c | 20 6f 72 20 61 20 63 61 |e value,| or a ca|
|00004480| 73 68 20 62 61 6c 61 6e | 63 65 20 79 6f 75 20 77 |sh balan|ce you w|
|00004490| 61 6e 74 20 74 6f 20 61 | 74 74 61 69 6e 20 61 66 |ant to a|ttain af|
|000044a0| 74 65 72 20 74 68 65 20 | 6c 61 73 74 20 70 61 79 |ter the |last pay|
|000044b0| 6d 65 6e 74 20 69 73 20 | 6d 61 64 65 2e 20 49 66 |ment is |made. If|
|000044c0| 20 6f 6d 69 74 74 65 64 | 2c 20 7a 65 72 6f 20 69 | omitted|, zero i|
|000044d0| 73 20 75 73 65 64 6f 69 | 73 20 61 20 6c 6f 67 69 |s usedoi|s a logi|
|000044e0| 63 61 6c 20 76 61 6c 75 | 65 3a 20 70 61 79 6d 65 |cal valu|e: payme|
|000044f0| 6e 74 20 61 74 20 74 68 | 65 20 62 65 67 69 6e 6e |nt at th|e beginn|
|00004500| 69 6e 67 20 6f 66 20 74 | 68 65 20 70 65 72 69 6f |ing of t|he perio|
|00004510| 64 20 3d 20 31 3b 20 70 | 61 79 6d 65 6e 74 20 61 |d = 1; p|ayment a|
|00004520| 74 20 74 68 65 20 65 6e | 64 20 6f 66 20 74 68 65 |t the en|d of the|
|00004530| 20 70 65 72 69 6f 64 20 | 3d 20 30 20 6f 72 20 6f | period |= 0 or o|
|00004540| 6d 69 74 74 65 64 00 14 | 72 61 74 65 2c 6e 70 65 |mitted..|rate,npe|
|00004550| 72 2c 70 76 2c 66 76 2c | 74 79 70 65 00 59 43 61 |r,pv,fv,|type.YCa|
|00004560| 6c 63 75 6c 61 74 65 73 | 20 74 68 65 20 70 61 79 |lculates| the pay|
|00004570| 6d 65 6e 74 20 66 6f 72 | 20 61 20 6c 6f 61 6e 20 |ment for| a loan |
|00004580| 62 61 73 65 64 20 6f 6e | 20 63 6f 6e 73 74 61 6e |based on| constan|
|00004590| 74 20 70 61 79 6d 65 6e | 74 73 20 61 6e 64 20 61 |t paymen|ts and a|
|000045a0| 20 63 6f 6e 73 74 61 6e | 74 20 69 6e 74 65 72 65 | constan|t intere|
|000045b0| 73 74 20 72 61 74 65 2c | 69 73 20 74 68 65 20 69 |st rate,|is the i|
|000045c0| 6e 74 65 72 65 73 74 20 | 72 61 74 65 20 70 65 72 |nterest |rate per|
|000045d0| 20 70 65 72 69 6f 64 20 | 66 6f 72 20 74 68 65 20 | period |for the |
|000045e0| 6c 6f 61 6e 2c 69 73 20 | 74 68 65 20 74 6f 74 61 |loan,is |the tota|
|000045f0| 6c 20 6e 75 6d 62 65 72 | 20 6f 66 20 70 61 79 6d |l number| of paym|
|00004600| 65 6e 74 73 20 66 6f 72 | 20 74 68 65 20 6c 6f 61 |ents for| the loa|
|00004610| 6e 54 69 73 20 74 68 65 | 20 70 72 65 73 65 6e 74 |nTis the| present|
|00004620| 20 76 61 6c 75 65 3a 20 | 74 68 65 20 74 6f 74 61 | value: |the tota|
|00004630| 6c 20 61 6d 6f 75 6e 74 | 20 74 68 61 74 20 61 20 |l amount| that a |
|00004640| 73 65 72 69 65 73 20 6f | 66 20 66 75 74 75 72 65 |series o|f future|
|00004650| 20 70 61 79 6d 65 6e 74 | 73 20 69 73 20 77 6f 72 | payment|s is wor|
|00004660| 74 68 20 6e 6f 77 6d 69 | 73 20 74 68 65 20 66 75 |th nowmi|s the fu|
|00004670| 74 75 72 65 20 76 61 6c | 75 65 2c 20 6f 72 20 61 |ture val|ue, or a|
|00004680| 20 63 61 73 68 20 62 61 | 6c 61 6e 63 65 20 79 6f | cash ba|lance yo|
|00004690| 75 20 77 61 6e 74 20 74 | 6f 20 61 74 74 61 69 6e |u want t|o attain|
|000046a0| 20 61 66 74 65 72 20 74 | 68 65 20 6c 61 73 74 20 | after t|he last |
|000046b0| 70 61 79 6d 65 6e 74 20 | 69 73 20 6d 61 64 65 2c |payment |is made,|
|000046c0| 20 30 20 28 7a 65 72 6f | 29 20 69 66 20 6f 6d 69 | 0 (zero|) if omi|
|000046d0| 74 74 65 64 6f 69 73 20 | 61 20 6c 6f 67 69 63 61 |ttedois |a logica|
|000046e0| 6c 20 76 61 6c 75 65 3a | 20 70 61 79 6d 65 6e 74 |l value:| payment|
|000046f0| 20 61 74 20 74 68 65 20 | 62 65 67 69 6e 6e 69 6e | at the |beginnin|
|00004700| 67 20 6f 66 20 74 68 65 | 20 70 65 72 69 6f 64 20 |g of the| period |
|00004710| 3d 20 31 3b 20 70 61 79 | 6d 65 6e 74 20 61 74 20 |= 1; pay|ment at |
|00004720| 74 68 65 20 65 6e 64 20 | 6f 66 20 74 68 65 20 70 |the end |of the p|
|00004730| 65 72 69 6f 64 20 3d 20 | 30 20 6f 72 20 6f 6d 69 |eriod = |0 or omi|
|00004740| 74 74 65 64 00 19 6e 70 | 65 72 2c 70 6d 74 2c 70 |tted..np|er,pmt,p|
|00004750| 76 2c 66 76 2c 74 79 70 | 65 2c 67 75 65 73 73 00 |v,fv,typ|e,guess.|
|00004760| 3c 52 65 74 75 72 6e 73 | 20 74 68 65 20 69 6e 74 |<Returns| the int|
|00004770| 65 72 65 73 74 20 72 61 | 74 65 20 70 65 72 20 70 |erest ra|te per p|
|00004780| 65 72 69 6f 64 20 6f 66 | 20 61 20 6c 6f 61 6e 20 |eriod of| a loan |
|00004790| 6f 72 20 61 6e 20 61 6e | 6e 75 69 74 79 3e 69 73 |or an an|nuity>is|
|000047a0| 20 74 68 65 20 74 6f 74 | 61 6c 20 6e 75 6d 62 65 | the tot|al numbe|
|000047b0| 72 20 6f 66 20 70 61 79 | 6d 65 6e 74 20 70 65 72 |r of pay|ment per|
|000047c0| 69 6f 64 73 20 66 6f 72 | 20 74 68 65 20 6c 6f 61 |iods for| the loa|
|000047d0| 6e 20 6f 72 20 61 6e 6e | 75 69 74 79 56 69 73 20 |n or ann|uityVis |
|000047e0| 74 68 65 20 70 61 79 6d | 65 6e 74 20 6d 61 64 65 |the paym|ent made|
|000047f0| 20 65 61 63 68 20 70 65 | 72 69 6f 64 20 61 6e 64 | each pe|riod and|
|00004800| 20 63 61 6e 6e 6f 74 20 | 63 68 61 6e 67 65 20 6f | cannot |change o|
|00004810| 76 65 72 20 74 68 65 20 | 6c 69 66 65 20 6f 66 20 |ver the |life of |
|00004820| 74 68 65 20 6c 61 6f 6e | 20 6f 72 20 61 6e 6e 75 |the laon| or annu|
|00004830| 69 74 79 54 69 73 20 74 | 68 65 20 70 72 65 73 65 |ityTis t|he prese|
|00004840| 6e 74 20 76 61 6c 75 65 | 3a 20 74 68 65 20 74 6f |nt value|: the to|
|00004850| 74 61 6c 20 61 6d 6f 75 | 6e 74 20 74 68 61 74 20 |tal amou|nt that |
|00004860| 61 20 73 65 72 69 65 73 | 20 6f 66 20 66 75 74 75 |a series| of futu|
|00004870| 72 65 20 70 61 79 6d 65 | 6e 74 73 20 69 73 20 77 |re payme|nts is w|
|00004880| 6f 72 74 68 20 6e 6f 77 | 71 69 73 20 74 68 65 20 |orth now|qis the |
|00004890| 66 75 74 75 72 65 20 76 | 61 6c 75 65 2c 20 6f 72 |future v|alue, or|
|000048a0| 20 61 20 63 61 73 68 20 | 62 61 6c 61 6e 63 65 20 | a cash |balance |
|000048b0| 79 6f 75 20 77 61 6e 74 | 20 74 6f 20 61 74 74 61 |you want| to atta|
|000048c0| 69 6e 20 61 66 74 65 72 | 20 74 68 65 20 6c 61 73 |in after| the las|
|000048d0| 74 20 70 61 79 6d 65 6e | 74 20 69 73 20 6d 61 64 |t paymen|t is mad|
|000048e0| 65 2e 20 49 66 20 6f 6d | 69 74 74 65 64 2c 20 75 |e. If om|itted, u|
|000048f0| 73 65 73 20 46 76 20 3d | 20 30 6f 69 73 20 61 20 |ses Fv =| 0ois a |
|00004900| 6c 6f 67 69 63 61 6c 20 | 76 61 6c 75 65 3a 20 70 |logical |value: p|
|00004910| 61 79 6d 65 6e 74 20 61 | 74 20 74 68 65 20 62 65 |ayment a|t the be|
|00004920| 67 69 6e 6e 69 6e 67 20 | 6f 66 20 74 68 65 20 70 |ginning |of the p|
|00004930| 65 72 69 6f 64 20 3d 20 | 31 3b 20 70 61 79 6d 65 |eriod = |1; payme|
|00004940| 6e 74 20 61 74 20 74 68 | 65 20 65 6e 64 20 6f 66 |nt at th|e end of|
|00004950| 20 74 68 65 20 70 65 72 | 69 6f 64 20 3d 20 30 20 | the per|iod = 0 |
|00004960| 6f 72 20 6f 6d 69 74 74 | 65 64 4d 69 73 20 79 6f |or omitt|edMis yo|
|00004970| 75 72 20 67 75 65 73 73 | 20 66 6f 72 20 77 68 61 |ur guess| for wha|
|00004980| 74 20 74 68 65 20 72 61 | 74 65 20 77 69 6c 6c 20 |t the ra|te will |
|00004990| 62 65 3b 20 69 66 20 6f | 6d 69 74 74 65 64 2c 20 |be; if o|mitted, |
|000049a0| 47 75 65 73 73 20 3d 20 | 30 2e 31 20 28 31 30 20 |Guess = |0.1 (10 |
|000049b0| 70 65 72 63 65 6e 74 29 | 00 21 76 61 6c 75 65 73 |percent)|.!values|
|000049c0| 2c 66 69 6e 61 6e 63 65 | 5f 72 61 74 65 2c 72 65 |,finance|_rate,re|
|000049d0| 69 6e 76 65 73 74 5f 72 | 61 74 65 00 91 52 65 74 |invest_r|ate..Ret|
|000049e0| 75 72 6e 73 20 74 68 65 | 20 69 6e 74 65 72 6e 61 |urns the| interna|
|000049f0| 6c 20 72 61 74 65 20 6f | 66 20 72 65 74 75 72 6e |l rate o|f return|
|00004a00| 20 66 6f 72 20 61 20 73 | 65 72 69 65 73 20 6f 66 | for a s|eries of|
|00004a10| 20 70 65 72 69 6f 64 69 | 63 20 63 61 73 68 20 66 | periodi|c cash f|
|00004a20| 6c 6f 77 73 2c 20 63 6f | 6e 73 69 64 65 72 69 6e |lows, co|nsiderin|
|00004a30| 67 20 62 6f 74 68 20 63 | 6f 73 74 20 6f 66 20 69 |g both c|ost of i|
|00004a40| 6e 76 65 73 74 6d 65 6e | 74 20 61 6e 64 20 69 6e |nvestmen|t and in|
|00004a50| 74 65 72 65 73 74 20 6f | 6e 20 72 65 69 6e 76 65 |terest o|n reinve|
|00004a60| 73 74 6d 65 6e 74 20 6f | 66 20 63 61 73 68 90 69 |stment o|f cash.i|
|00004a70| 73 20 61 6e 20 61 72 72 | 61 79 20 6f 72 20 61 20 |s an arr|ay or a |
|00004a80| 72 65 66 65 72 65 6e 63 | 65 20 74 6f 20 63 65 6c |referenc|e to cel|
|00004a90| 6c 73 20 74 68 61 74 20 | 63 6f 6e 74 61 69 6e 20 |ls that |contain |
|00004aa0| 6e 75 6d 62 65 72 73 20 | 74 68 61 74 20 72 65 70 |numbers |that rep|
|00004ab0| 72 65 73 65 6e 74 20 61 | 20 73 65 72 69 65 73 20 |resent a| series |
|00004ac0| 6f 66 20 70 61 79 6d 65 | 6e 74 73 20 28 6e 65 67 |of payme|nts (neg|
|00004ad0| 61 74 69 76 65 29 20 61 | 6e 64 20 69 6e 63 6f 6d |ative) a|nd incom|
|00004ae0| 65 20 28 70 6f 73 69 74 | 69 76 65 29 20 61 74 20 |e (posit|ive) at |
|00004af0| 72 65 67 75 6c 61 72 20 | 70 65 72 69 6f 64 73 40 |regular |periods@|
|00004b00| 69 73 20 74 68 65 20 69 | 6e 74 65 72 65 73 74 20 |is the i|nterest |
|00004b10| 72 61 74 65 20 79 6f 75 | 20 70 61 79 20 6f 6e 20 |rate you| pay on |
|00004b20| 74 68 65 20 6d 6f 6e 65 | 79 20 75 73 65 64 20 69 |the mone|y used i|
|00004b30| 6e 20 74 68 65 20 63 61 | 73 68 20 66 6c 6f 77 73 |n the ca|sh flows|
|00004b40| 47 69 73 20 74 68 65 20 | 69 6e 74 65 72 65 73 74 |Gis the |interest|
|00004b50| 20 72 61 74 65 20 79 6f | 75 20 72 65 63 65 69 76 | rate yo|u receiv|
|00004b60| 65 20 6f 6e 20 74 68 65 | 20 63 61 73 68 20 66 6c |e on the| cash fl|
|00004b70| 6f 77 73 20 61 73 20 79 | 6f 75 20 72 65 69 6e 76 |ows as y|ou reinv|
|00004b80| 65 73 74 20 74 68 65 6d | 00 0c 76 61 6c 75 65 73 |est them|..values|
|00004b90| 2c 67 75 65 73 73 00 3e | 52 65 74 75 72 6e 73 20 |,guess.>|Returns |
|00004ba0| 74 68 65 20 69 6e 74 65 | 72 6e 61 6c 20 72 61 74 |the inte|rnal rat|
|00004bb0| 65 20 6f 66 20 72 65 74 | 75 72 6e 20 66 6f 72 20 |e of ret|urn for |
|00004bc0| 61 20 73 65 72 69 65 73 | 20 6f 66 20 63 61 73 68 |a series| of cash|
|00004bd0| 20 66 6c 6f 77 73 74 69 | 73 20 61 6e 20 61 72 72 | flowsti|s an arr|
|00004be0| 61 79 20 6f 72 20 61 20 | 72 65 66 65 72 65 6e 63 |ay or a |referenc|
|00004bf0| 65 20 74 6f 20 63 65 6c | 6c 73 20 74 68 61 74 20 |e to cel|ls that |
|00004c00| 63 6f 6e 74 61 69 6e 20 | 6e 75 6d 62 65 72 73 20 |contain |numbers |
|00004c10| 66 6f 72 20 77 68 69 63 | 68 20 79 6f 75 20 77 61 |for whic|h you wa|
|00004c20| 6e 74 20 74 6f 20 63 61 | 6c 63 75 6c 61 74 65 20 |nt to ca|lculate |
|00004c30| 74 68 65 20 69 6e 74 65 | 72 6e 61 6c 20 72 61 74 |the inte|rnal rat|
|00004c40| 65 20 6f 66 20 72 65 74 | 75 72 6e 55 69 73 20 61 |e of ret|urnUis a|
|00004c50| 20 6e 75 6d 62 65 72 20 | 74 68 61 74 20 79 6f 75 | number |that you|
|00004c60| 20 67 75 65 73 73 20 69 | 73 20 63 6c 6f 73 65 20 | guess i|s close |
|00004c70| 74 6f 20 74 68 65 20 72 | 65 73 75 6c 74 20 6f 66 |to the r|esult of|
|00004c80| 20 49 52 52 3b 20 30 2e | 31 20 28 31 30 20 70 65 | IRR; 0.|1 (10 pe|
|00004c90| 72 63 65 6e 74 29 20 69 | 66 20 6f 6d 69 74 74 65 |rcent) i|f omitte|
|00004ca0| 64 00 00 71 52 65 74 75 | 72 6e 73 20 61 6e 20 65 |d..qRetu|rns an e|
|00004cb0| 76 65 6e 6c 79 20 64 69 | 73 74 72 69 62 75 74 65 |venly di|stribute|
|00004cc0| 64 20 72 61 6e 64 6f 6d | 20 6e 75 6d 62 65 72 20 |d random| number |
|00004cd0| 67 72 65 61 74 65 72 20 | 74 68 61 6e 20 6f 72 20 |greater |than or |
|00004ce0| 65 71 75 61 6c 20 74 6f | 20 30 20 61 6e 64 20 6c |equal to| 0 and l|
|00004cf0| 65 73 73 20 74 68 61 6e | 20 31 20 28 63 68 61 6e |ess than| 1 (chan|
|00004d00| 67 65 73 20 6f 6e 20 72 | 65 63 61 6c 63 75 6c 61 |ges on r|ecalcula|
|00004d10| 74 69 6f 6e 29 00 24 6c | 6f 6f 6b 75 70 5f 76 61 |tion).$l|ookup_va|
|00004d20| 6c 75 65 2c 6c 6f 6f 6b | 75 70 5f 61 72 72 61 79 |lue,look|up_array|
|00004d30| 2c 6d 61 74 63 68 5f 74 | 79 70 65 00 68 52 65 74 |,match_t|ype.hRet|
|00004d40| 75 72 6e 73 20 74 68 65 | 20 72 65 6c 61 74 69 76 |urns the| relativ|
|00004d50| 65 20 70 6f 73 69 74 69 | 6f 6e 20 6f 66 20 61 6e |e positi|on of an|
|00004d60| 20 69 74 65 6d 20 69 6e | 20 61 6e 20 61 72 72 61 | item in| an arra|
|00004d70| 79 20 74 68 61 74 20 6d | 61 74 63 68 65 73 20 61 |y that m|atches a|
|00004d80| 20 73 70 65 63 69 66 69 | 65 64 20 76 61 6c 75 65 | specifi|ed value|
|00004d90| 20 69 6e 20 61 20 73 70 | 65 63 69 66 69 65 64 20 | in a sp|ecified |
|00004da0| 6f 72 64 65 72 7e 69 73 | 20 74 68 65 20 76 61 6c |order~is| the val|
|00004db0| 75 65 20 79 6f 75 20 75 | 73 65 20 74 6f 20 66 69 |ue you u|se to fi|
|00004dc0| 6e 64 20 74 68 65 20 76 | 61 6c 75 65 20 79 6f 75 |nd the v|alue you|
|00004dd0| 20 77 61 6e 74 20 69 6e | 20 74 68 65 20 61 72 72 | want in| the arr|
|00004de0| 61 79 2c 20 61 20 6e 75 | 6d 62 65 72 2c 20 74 65 |ay, a nu|mber, te|
|00004df0| 78 74 2c 20 6f 72 20 6c | 6f 67 69 63 61 6c 20 76 |xt, or l|ogical v|
|00004e00| 61 6c 75 65 2c 20 6f 72 | 20 61 20 72 65 66 65 72 |alue, or| a refer|
|00004e10| 65 6e 63 65 20 74 6f 20 | 6f 6e 65 20 6f 66 20 74 |ence to |one of t|
|00004e20| 68 65 73 65 70 69 73 20 | 61 20 63 6f 6e 74 69 67 |hesepis |a contig|
|00004e30| 75 6f 75 73 20 72 61 6e | 67 65 20 6f 66 20 63 65 |uous ran|ge of ce|
|00004e40| 6c 6c 73 20 63 6f 6e 74 | 61 69 6e 69 6e 67 20 70 |lls cont|aining p|
|00004e50| 6f 73 73 69 62 6c 65 20 | 6c 6f 6f 6b 75 70 20 76 |ossible |lookup v|
|00004e60| 61 6c 75 65 73 2c 20 61 | 6e 20 61 72 72 61 79 20 |alues, a|n array |
|00004e70| 6f 66 20 76 61 6c 75 65 | 73 2c 20 6f 72 20 61 20 |of value|s, or a |
|00004e80| 72 65 66 65 72 65 6e 63 | 65 20 74 6f 20 61 6e 20 |referenc|e to an |
|00004e90| 61 72 72 61 79 67 69 73 | 20 61 20 6e 75 6d 62 65 |arraygis| a numbe|
|00004ea0| 72 20 31 2c 20 30 2c 20 | 6f 72 20 2d 31 20 69 6e |r 1, 0, |or -1 in|
|00004eb0| 64 69 63 61 74 69 6e 67 | 20 77 68 69 63 68 20 76 |dicating| which v|
|00004ec0| 61 6c 75 65 20 74 6f 20 | 72 65 74 75 72 6e 2e 20 |alue to |return. |
|00004ed0| 53 65 65 20 48 65 6c 70 | 20 66 6f 72 20 65 78 70 |See Help| for exp|
|00004ee0| 6c 61 6e 61 74 69 6f 6e | 73 20 6f 66 20 74 68 65 |lanation|s of the|
|00004ef0| 20 6d 61 74 63 68 20 74 | 79 70 65 73 2e 00 0e 79 | match t|ypes...y|
|00004f00| 65 61 72 2c 6d 6f 6e 74 | 68 2c 64 61 79 00 4e 52 |ear,mont|h,day.NR|
|00004f10| 65 74 75 72 6e 73 20 74 | 68 65 20 6e 75 6d 62 65 |eturns t|he numbe|
|00004f20| 72 20 74 68 61 74 20 72 | 65 70 72 65 73 65 6e 74 |r that r|epresent|
|00004f30| 73 20 74 68 65 20 64 61 | 74 65 20 69 6e 20 4d 69 |s the da|te in Mi|
|00004f40| 63 72 6f 73 6f 66 74 20 | 45 78 63 65 6c 20 64 61 |crosoft |Excel da|
|00004f50| 74 65 2d 74 69 6d 65 20 | 63 6f 64 65 2e 76 69 73 |te-time |code.vis|
|00004f60| 20 61 20 6e 75 6d 62 65 | 72 20 66 72 6f 6d 20 31 | a numbe|r from 1|
|00004f70| 39 30 30 20 74 6f 20 39 | 39 39 39 20 69 6e 20 4d |900 to 9|999 in M|
|00004f80| 69 63 72 6f 73 6f 66 74 | 20 45 78 63 65 6c 20 66 |icrosoft| Excel f|
|00004f90| 6f 72 20 57 69 6e 64 6f | 77 73 20 6f 72 20 66 72 |or Windo|ws or fr|
|00004fa0| 6f 6d 20 31 39 30 34 20 | 74 6f 20 39 39 39 39 20 |om 1904 |to 9999 |
|00004fb0| 69 6e 20 4d 69 63 72 6f | 73 6f 66 74 20 45 78 63 |in Micro|soft Exc|
|00004fc0| 65 6c 20 66 6f 72 20 74 | 68 65 20 4d 61 63 69 6e |el for t|he Macin|
|00004fd0| 74 6f 73 68 3b 69 73 20 | 61 20 6e 75 6d 62 65 72 |tosh;is |a number|
|00004fe0| 20 66 72 6f 6d 20 31 20 | 74 6f 20 31 32 20 72 65 | from 1 |to 12 re|
|00004ff0| 70 72 65 73 65 6e 74 69 | 6e 67 20 74 68 65 20 6d |presenti|ng the m|
|00005000| 6f 6e 74 68 20 6f 66 20 | 74 68 65 20 79 65 61 72 |onth of |the year|
|00005010| 3a 69 73 20 61 20 6e 75 | 6d 62 65 72 20 66 72 6f |:is a nu|mber fro|
|00005020| 6d 20 31 20 74 6f 20 33 | 31 20 72 65 70 72 65 73 |m 1 to 3|1 repres|
|00005030| 65 6e 74 69 6e 67 20 74 | 68 65 20 64 61 79 20 6f |enting t|he day o|
|00005040| 66 20 74 68 65 20 6d 6f | 6e 74 68 00 12 68 6f 75 |f the mo|nth..hou|
|00005050| 72 2c 6d 69 6e 75 74 65 | 2c 73 65 63 6f 6e 64 00 |r,minute|,second.|
|00005060| 95 52 65 74 75 72 6e 73 | 20 74 68 65 20 6e 75 6d |.Returns| the num|
|00005070| 62 65 72 20 74 68 61 74 | 20 72 65 70 72 65 73 65 |ber that| represe|
|00005080| 6e 74 73 20 61 20 70 61 | 72 74 69 63 75 6c 61 72 |nts a pa|rticular|
|00005090| 20 74 69 6d 65 3a 20 61 | 20 64 65 63 69 6d 61 6c | time: a| decimal|
|000050a0| 20 66 72 61 63 74 69 6f | 6e 20 66 72 6f 6d 20 30 | fractio|n from 0|
|000050b0| 20 74 6f 20 30 2e 39 39 | 39 39 39 39 39 39 20 66 | to 0.99|999999 f|
|000050c0| 6f 72 20 30 3a 30 30 3a | 30 30 20 28 31 32 3a 30 |or 0:00:|00 (12:0|
|000050d0| 30 3a 30 30 20 41 2e 4d | 2e 29 20 74 6f 20 32 33 |0:00 A.M|.) to 23|
|000050e0| 3a 35 39 3a 35 39 20 28 | 31 31 3a 35 39 3a 35 39 |:59:59 (|11:59:59|
|000050f0| 20 50 2e 4d 2e 29 2e 69 | 73 20 61 20 6e 75 6d 62 | P.M.).i|s a numb|
|00005100| 65 72 20 66 72 6f 6d 20 | 30 20 74 6f 20 32 33 20 |er from |0 to 23 |
|00005110| 72 65 70 72 65 73 65 6e | 74 69 6e 67 20 74 68 65 |represen|ting the|
|00005120| 20 68 6f 75 72 30 69 73 | 20 61 20 6e 75 6d 62 65 | hour0is| a numbe|
|00005130| 72 20 66 72 6f 6d 20 30 | 20 74 6f 20 35 39 20 72 |r from 0| to 59 r|
|00005140| 65 70 72 65 73 65 6e 74 | 69 6e 67 20 74 68 65 20 |epresent|ing the |
|00005150| 6d 69 6e 75 74 65 30 69 | 73 20 61 20 6e 75 6d 62 |minute0i|s a numb|
|00005160| 65 72 20 66 72 6f 6d 20 | 30 20 74 6f 20 35 39 20 |er from |0 to 59 |
|00005170| 72 65 70 72 65 73 65 6e | 74 69 6e 67 20 74 68 65 |represen|ting the|
|00005180| 20 73 65 63 6f 6e 64 00 | 0d 73 65 72 69 61 6c 5f | second.|.serial_|
|00005190| 6e 75 6d 62 65 72 00 65 | 52 65 74 75 72 6e 73 20 |number.e|Returns |
|000051a0| 74 68 65 20 64 61 79 20 | 6f 66 20 74 68 65 20 6d |the day |of the m|
|000051b0| 6f 6e 74 68 20 28 61 20 | 6e 75 6d 62 65 72 20 66 |onth (a |number f|
|000051c0| 72 6f 6d 20 31 20 74 6f | 20 33 31 29 20 63 6f 72 |rom 1 to| 31) cor|
|000051d0| 72 65 73 70 6f 6e 64 69 | 6e 67 20 74 6f 20 61 20 |respondi|ng to a |
|000051e0| 6e 75 6d 62 65 72 20 74 | 68 61 74 20 72 65 70 72 |number t|hat repr|
|000051f0| 65 73 65 6e 74 73 20 61 | 20 64 61 74 65 6d 69 73 |esents a| datemis|
|00005200| 20 61 20 6e 75 6d 62 65 | 72 20 69 6e 20 74 68 65 | a numbe|r in the|
|00005210| 20 64 61 74 65 2d 74 69 | 6d 65 20 63 6f 64 65 20 | date-ti|me code |
|00005220| 75 73 65 64 20 62 79 20 | 4d 69 63 72 6f 73 6f 66 |used by |Microsof|
|00005230| 74 20 45 78 63 65 6c 20 | 6f 72 20 74 65 78 74 20 |t Excel |or text |
|00005240| 69 6e 20 64 61 74 65 20 | 66 6f 72 6d 61 74 2c 20 |in date |format, |
|00005250| 73 75 63 68 20 61 73 20 | 34 2d 31 2d 39 38 20 6f |such as |4-1-98 o|
|00005260| 72 20 33 31 2d 4f 63 74 | 2d 39 39 00 0d 73 65 72 |r 31-Oct|-99..ser|
|00005270| 69 61 6c 5f 6e 75 6d 62 | 65 72 00 61 52 65 74 75 |ial_numb|er.aRetu|
|00005280| 72 6e 73 20 74 68 65 20 | 6d 6f 6e 74 68 2c 20 61 |rns the |month, a|
|00005290| 6e 20 69 6e 74 65 67 65 | 72 20 66 72 6f 6d 20 31 |n intege|r from 1|
|000052a0| 20 28 4a 61 6e 75 61 72 | 79 29 20 74 6f 20 31 32 | (Januar|y) to 12|
|000052b0| 20 28 44 65 63 65 6d 62 | 65 72 29 2c 20 63 6f 72 | (Decemb|er), cor|
|000052c0| 72 65 73 70 6f 6e 64 69 | 6e 67 20 74 6f 20 61 20 |respondi|ng to a |
|000052d0| 73 65 72 69 61 6c 20 6e | 75 6d 62 65 72 6d 69 73 |serial n|umbermis|
|000052e0| 20 61 20 6e 75 6d 62 65 | 72 20 69 6e 20 74 68 65 | a numbe|r in the|
|000052f0| 20 64 61 74 65 2d 74 69 | 6d 65 20 63 6f 64 65 20 | date-ti|me code |
|00005300| 75 73 65 64 20 62 79 20 | 4d 69 63 72 6f 73 6f 66 |used by |Microsof|
|00005310| 74 20 45 78 63 65 6c 20 | 6f 72 20 74 65 78 74 20 |t Excel |or text |
|00005320| 69 6e 20 64 61 74 65 20 | 66 6f 72 6d 61 74 2c 20 |in date |format, |
|00005330| 73 75 63 68 20 61 73 20 | 34 2d 31 2d 39 38 20 6f |such as |4-1-98 o|
|00005340| 72 20 33 31 2d 4f 63 74 | 2d 39 39 00 0d 73 65 72 |r 31-Oct|-99..ser|
|00005350| 69 61 6c 5f 6e 75 6d 62 | 65 72 00 67 52 65 74 75 |ial_numb|er.gRetu|
|00005360| 72 6e 73 20 74 68 65 20 | 79 65 61 72 2c 20 61 6e |rns the |year, an|
|00005370| 20 69 6e 74 65 67 65 72 | 20 69 6e 20 74 68 65 20 | integer| in the |
|00005380| 72 61 6e 67 65 20 31 39 | 30 30 20 2d 20 39 39 39 |range 19|00 - 999|
|00005390| 39 2c 20 63 6f 72 72 65 | 73 70 6f 6e 64 69 6e 67 |9, corre|sponding|
|000053a0| 20 74 6f 20 61 20 6e 75 | 6d 62 65 72 20 74 68 61 | to a nu|mber tha|
|000053b0| 74 20 72 65 70 72 65 73 | 65 6e 74 73 20 61 20 64 |t repres|ents a d|
|000053c0| 61 74 65 6d 69 73 20 61 | 20 6e 75 6d 62 65 72 20 |atemis a| number |
|000053d0| 69 6e 20 74 68 65 20 64 | 61 74 65 2d 74 69 6d 65 |in the d|ate-time|
|000053e0| 20 63 6f 64 65 20 75 73 | 65 64 20 62 79 20 4d 69 | code us|ed by Mi|
|000053f0| 63 72 6f 73 6f 66 74 20 | 45 78 63 65 6c 20 6f 72 |crosoft |Excel or|
|00005400| 20 74 65 78 74 20 69 6e | 20 64 61 74 65 20 66 6f | text in| date fo|
|00005410| 72 6d 61 74 2c 20 73 75 | 63 68 20 61 73 20 34 2d |rmat, su|ch as 4-|
|00005420| 31 2d 39 38 20 6f 72 20 | 33 31 2d 4f 63 74 2d 39 |1-98 or |31-Oct-9|
|00005430| 39 00 19 73 65 72 69 61 | 6c 5f 6e 75 6d 62 65 72 |9..seria|l_number|
|00005440| 2c 72 65 74 75 72 6e 5f | 74 79 70 65 00 6b 52 65 |,return_|type.kRe|
|00005450| 74 75 72 6e 73 20 61 20 | 6e 75 6d 62 65 72 20 66 |turns a |number f|
|00005460| 72 6f 6d 20 31 20 74 6f | 20 37 20 69 64 65 6e 74 |rom 1 to| 7 ident|
|00005470| 69 66 79 69 6e 67 20 74 | 68 65 20 64 61 79 20 6f |ifying t|he day o|
|00005480| 66 20 74 68 65 20 77 65 | 65 6b 20 62 61 73 65 64 |f the we|ek based|
|00005490| 20 6f 6e 20 61 20 67 69 | 76 65 6e 20 6e 75 6d 62 | on a gi|ven numb|
|000054a0| 65 72 20 74 68 61 74 20 | 72 65 70 72 65 73 65 6e |er that |represen|
|000054b0| 74 73 20 61 20 64 61 74 | 65 56 69 73 20 61 20 6e |ts a dat|eVis a n|
|000054c0| 75 6d 62 65 72 20 74 68 | 61 74 20 72 65 70 72 65 |umber th|at repre|
|000054d0| 73 65 6e 74 73 20 61 20 | 64 61 74 65 20 6f 72 20 |sents a |date or |
|000054e0| 74 65 78 74 20 69 6e 20 | 64 61 74 65 20 66 6f 72 |text in |date for|
|000054f0| 6d 61 74 2c 20 73 75 63 | 68 20 61 73 20 34 2d 31 |mat, suc|h as 4-1|
|00005500| 2d 39 38 20 6f 72 20 33 | 31 2d 4f 63 74 2d 39 39 |-98 or 3|1-Oct-99|
|00005510| 7f 69 73 20 61 20 6e 75 | 6d 62 65 72 3a 20 66 6f |.is a nu|mber: fo|
|00005520| 72 20 53 75 6e 64 61 79 | 3d 31 20 74 68 72 6f 75 |r Sunday|=1 throu|
|00005530| 67 68 20 53 61 74 75 72 | 64 61 79 3d 37 2c 20 75 |gh Satur|day=7, u|
|00005540| 73 65 20 31 3b 20 66 6f | 72 20 4d 6f 6e 64 61 79 |se 1; fo|r Monday|
|00005550| 3d 31 20 74 68 72 6f 75 | 67 68 20 53 75 6e 64 61 |=1 throu|gh Sunda|
|00005560| 79 3d 37 2c 20 75 73 65 | 20 32 3b 20 66 6f 72 20 |y=7, use| 2; for |
|00005570| 4d 6f 6e 64 61 79 3d 30 | 20 74 68 72 6f 75 67 68 |Monday=0| through|
|00005580| 20 53 75 6e 64 61 79 3d | 31 2c 20 75 73 65 20 33 | Sunday=|1, use 3|
|00005590| 00 0d 73 65 72 69 61 6c | 5f 6e 75 6d 62 65 72 00 |..serial|_number.|
|000055a0| 64 52 65 74 75 72 6e 73 | 20 74 68 65 20 68 6f 75 |dReturns| the hou|
|000055b0| 72 2c 20 61 6e 20 69 6e | 74 65 67 65 72 20 66 72 |r, an in|teger fr|
|000055c0| 6f 6d 20 30 20 28 31 32 | 3a 30 30 20 41 2e 4d 2e |om 0 (12|:00 A.M.|
|000055d0| 29 20 74 6f 20 32 33 20 | 28 31 31 3a 30 30 20 50 |) to 23 |(11:00 P|
|000055e0| 2e 4d 2e 29 20 63 6f 72 | 72 65 73 70 6f 6e 64 69 |.M.) cor|respondi|
|000055f0| 6e 67 20 74 6f 20 61 20 | 73 65 72 69 61 6c 20 6e |ng to a |serial n|
|00005600| 75 6d 62 65 72 71 69 73 | 20 61 20 6e 75 6d 62 65 |umberqis| a numbe|
|00005610| 72 20 69 6e 20 74 68 65 | 20 64 61 74 65 2d 74 69 |r in the| date-ti|
|00005620| 6d 65 20 63 6f 64 65 20 | 75 73 65 64 20 62 79 20 |me code |used by |
|00005630| 4d 69 63 72 6f 73 6f 66 | 74 20 45 78 63 65 6c 2c |Microsof|t Excel,|
|00005640| 20 6f 72 20 74 65 78 74 | 20 69 6e 20 74 69 6d 65 | or text| in time|
|00005650| 20 66 6f 72 6d 61 74 2c | 20 73 75 63 68 20 61 73 | format,| such as|
|00005660| 20 31 36 3a 34 38 3a 30 | 30 20 6f 72 20 34 3a 34 | 16:48:0|0 or 4:4|
|00005670| 38 3a 30 30 20 50 4d 00 | 0d 73 65 72 69 61 6c 5f |8:00 PM.|.serial_|
|00005680| 6e 75 6d 62 65 72 00 4d | 52 65 74 75 72 6e 73 20 |number.M|Returns |
|00005690| 74 68 65 20 6d 69 6e 75 | 74 65 2c 20 61 6e 20 69 |the minu|te, an i|
|000056a0| 6e 74 65 67 65 72 20 66 | 72 6f 6d 20 30 20 74 6f |nteger f|rom 0 to|
|000056b0| 20 35 39 2c 20 63 6f 72 | 72 65 73 70 6f 6e 64 69 | 59, cor|respondi|
|000056c0| 6e 67 20 74 6f 20 61 20 | 73 65 72 69 61 6c 20 6e |ng to a |serial n|
|000056d0| 75 6d 62 65 72 70 69 73 | 20 61 20 6e 75 6d 62 65 |umberpis| a numbe|
|000056e0| 72 20 69 6e 20 74 68 65 | 20 64 61 74 65 2d 74 69 |r in the| date-ti|
|000056f0| 6d 65 20 63 6f 64 65 20 | 75 73 65 64 20 62 79 20 |me code |used by |
|00005700| 4d 69 63 72 6f 73 6f 66 | 74 20 45 78 63 65 6c 20 |Microsof|t Excel |
|00005710| 6f 72 20 74 65 78 74 20 | 69 6e 20 74 69 6d 65 20 |or text |in time |
|00005720| 66 6f 72 6d 61 74 2c 20 | 73 75 63 68 20 61 73 20 |format, |such as |
|00005730| 31 36 3a 34 38 3a 30 30 | 20 6f 72 20 34 3a 34 38 |16:48:00| or 4:48|
|00005740| 3a 30 30 20 50 4d 00 0d | 73 65 72 69 61 6c 5f 6e |:00 PM..|serial_n|
|00005750| 75 6d 62 65 72 00 55 52 | 65 74 75 72 6e 73 20 74 |umber.UR|eturns t|
|00005760| 68 65 20 73 65 63 6f 6e | 64 2c 20 61 6e 20 69 6e |he secon|d, an in|
|00005770| 74 65 67 65 72 20 69 6e | 20 74 68 65 20 72 61 6e |teger in| the ran|
|00005780| 67 65 20 30 20 74 6f 20 | 35 39 2c 20 63 6f 72 72 |ge 0 to |59, corr|
|00005790| 65 73 70 6f 6e 64 69 6e | 67 20 74 6f 20 61 20 73 |espondin|g to a s|
|000057a0| 65 72 69 61 6c 20 6e 75 | 6d 62 65 72 70 69 73 20 |erial nu|mberpis |
|000057b0| 61 20 6e 75 6d 62 65 72 | 20 69 6e 20 74 68 65 20 |a number| in the |
|000057c0| 64 61 74 65 2d 74 69 6d | 65 20 63 6f 64 65 20 75 |date-tim|e code u|
|000057d0| 73 65 64 20 62 79 20 4d | 69 63 72 6f 73 6f 66 74 |sed by M|icrosoft|
|000057e0| 20 45 78 63 65 6c 20 6f | 72 20 74 65 78 74 20 69 | Excel o|r text i|
|000057f0| 6e 20 74 69 6d 65 20 66 | 6f 72 6d 61 74 2c 20 73 |n time f|ormat, s|
|00005800| 75 63 68 20 61 73 20 31 | 36 3a 34 38 3a 32 33 20 |uch as 1|6:48:23 |
|00005810| 6f 72 20 34 3a 34 38 3a | 34 37 20 50 4d 00 00 64 |or 4:48:|47 PM..d|
|00005820| 52 65 74 75 72 6e 73 20 | 74 68 65 20 73 65 72 69 |Returns |the seri|
|00005830| 61 6c 20 6e 75 6d 62 65 | 72 20 6f 66 20 74 68 65 |al numbe|r of the|
|00005840| 20 63 75 72 72 65 6e 74 | 20 64 61 74 65 20 6f 72 | current| date or|
|00005850| 20 74 69 6d 65 2e 20 53 | 65 65 20 48 65 6c 70 20 | time. S|ee Help |
|00005860| 66 6f 72 20 69 6e 66 6f | 72 6d 61 74 69 6f 6e 20 |for info|rmation |
|00005870| 61 62 6f 75 74 20 73 65 | 72 69 61 6c 20 6e 75 6d |about se|rial num|
|00005880| 62 65 72 73 00 09 72 65 | 66 65 72 65 6e 63 65 00 |bers..re|ference.|
|00005890| 63 52 65 74 75 72 6e 73 | 20 74 68 65 20 6e 75 6d |cReturns| the num|
|000058a0| 62 65 72 20 6f 66 20 61 | 72 65 61 73 20 69 6e 20 |ber of a|reas in |
|000058b0| 61 20 72 65 66 65 72 65 | 6e 63 65 2e 20 41 6e 20 |a refere|nce. An |
|000058c0| 61 72 65 61 20 69 73 20 | 61 20 72 61 6e 67 65 20 |area is |a range |
|000058d0| 6f 66 20 63 6f 6e 74 69 | 67 75 6f 75 73 20 63 65 |of conti|guous ce|
|000058e0| 6c 6c 73 20 6f 72 20 61 | 20 73 69 6e 67 6c 65 20 |lls or a| single |
|000058f0| 63 65 6c 6c 4a 69 73 20 | 61 20 72 65 66 65 72 65 |cellJis |a refere|
|00005900| 6e 63 65 20 74 6f 20 61 | 20 63 65 6c 6c 20 6f 72 |nce to a| cell or|
|00005910| 20 72 61 6e 67 65 20 6f | 66 20 63 65 6c 6c 73 20 | range o|f cells |
|00005920| 61 6e 64 20 63 61 6e 20 | 72 65 66 65 72 20 74 6f |and can |refer to|
|00005930| 20 6d 75 6c 74 69 70 6c | 65 20 61 72 65 61 73 00 | multipl|e areas.|
|00005940| 05 61 72 72 61 79 00 32 | 52 65 74 75 72 6e 73 20 |.array.2|Returns |
|00005950| 74 68 65 20 6e 75 6d 62 | 65 72 20 6f 66 20 72 6f |the numb|er of ro|
|00005960| 77 73 20 69 6e 20 61 20 | 72 65 66 65 72 65 6e 63 |ws in a |referenc|
|00005970| 65 20 6f 72 20 61 72 72 | 61 79 67 69 73 20 61 6e |e or arr|aygis an|
|00005980| 20 61 72 72 61 79 2c 20 | 61 6e 20 61 72 72 61 79 | array, |an array|
|00005990| 20 66 6f 72 6d 75 6c 61 | 2c 20 6f 72 20 61 20 72 | formula|, or a r|
|000059a0| 65 66 65 72 65 6e 63 65 | 20 74 6f 20 61 20 72 61 |eference| to a ra|
|000059b0| 6e 67 65 20 6f 66 20 63 | 65 6c 6c 73 20 66 6f 72 |nge of c|ells for|
|000059c0| 20 77 68 69 63 68 20 79 | 6f 75 20 77 61 6e 74 20 | which y|ou want |
|000059d0| 74 68 65 20 6e 75 6d 62 | 65 72 20 6f 66 20 72 6f |the numb|er of ro|
|000059e0| 77 73 00 05 61 72 72 61 | 79 00 36 52 65 74 75 72 |ws..arra|y.6Retur|
|000059f0| 6e 73 20 74 68 65 20 6e | 75 6d 62 65 72 20 6f 66 |ns the n|umber of|
|00005a00| 20 63 6f 6c 75 6d 6e 73 | 20 69 6e 20 61 6e 20 61 | columns| in an a|
|00005a10| 72 72 61 79 20 6f 72 20 | 72 65 66 65 72 65 6e 63 |rray or |referenc|
|00005a20| 65 69 69 73 20 61 6e 20 | 61 72 72 61 79 20 6f 72 |eiis an |array or|
|00005a30| 20 61 72 72 61 79 20 66 | 6f 72 6d 75 6c 61 2c 20 | array f|ormula, |
|00005a40| 6f 72 20 61 20 72 65 66 | 65 72 65 6e 63 65 20 74 |or a ref|erence t|
|00005a50| 6f 20 61 20 72 61 6e 67 | 65 20 6f 66 20 63 65 6c |o a rang|e of cel|
|00005a60| 6c 73 20 66 6f 72 20 77 | 68 69 63 68 20 79 6f 75 |ls for w|hich you|
|00005a70| 20 77 61 6e 74 20 74 68 | 65 20 6e 75 6d 62 65 72 | want th|e number|
|00005a80| 20 6f 66 20 63 6f 6c 75 | 6d 6e 73 00 20 72 65 66 | of colu|mns. ref|
|00005a90| 65 72 65 6e 63 65 2c 72 | 6f 77 73 2c 63 6f 6c 73 |erence,r|ows,cols|
|00005aa0| 2c 68 65 69 67 68 74 2c | 77 69 64 74 68 00 6b 52 |,height,|width.kR|
|00005ab0| 65 74 75 72 6e 73 20 61 | 20 72 65 66 65 72 65 6e |eturns a| referen|
|00005ac0| 63 65 20 74 6f 20 61 20 | 72 61 6e 67 65 20 74 68 |ce to a |range th|
|00005ad0| 61 74 20 69 73 20 61 20 | 73 70 65 63 69 66 69 65 |at is a |specifie|
|00005ae0| 64 20 6e 75 6d 62 65 72 | 20 6f 66 20 72 6f 77 73 |d number| of rows|
|00005af0| 20 61 6e 64 20 63 6f 6c | 75 6d 6e 73 20 66 72 6f | and col|umns fro|
|00005b00| 6d 20 61 20 63 65 6c 6c | 20 6f 72 20 72 61 6e 67 |m a cell| or rang|
|00005b10| 65 20 6f 66 20 63 65 6c | 6c 73 69 69 73 20 74 68 |e of cel|lsiis th|
|00005b20| 65 20 72 65 66 65 72 65 | 6e 63 65 20 66 72 6f 6d |e refere|nce from|
|00005b30| 20 77 68 69 63 68 20 79 | 6f 75 20 77 61 6e 74 20 | which y|ou want |
|00005b40| 74 6f 20 62 61 73 65 20 | 74 68 65 20 6f 66 66 73 |to base |the offs|
|00005b50| 65 74 2c 20 61 20 72 65 | 66 65 72 65 6e 63 65 20 |et, a re|ference |
|00005b60| 74 6f 20 61 20 63 65 6c | 6c 20 6f 72 20 72 61 6e |to a cel|l or ran|
|00005b70| 67 65 20 6f 66 20 61 64 | 6a 61 63 65 6e 74 20 63 |ge of ad|jacent c|
|00005b80| 65 6c 6c 73 5e 69 73 20 | 74 68 65 20 6e 75 6d 62 |ells^is |the numb|
|00005b90| 65 72 20 6f 66 20 72 6f | 77 73 2c 20 75 70 20 6f |er of ro|ws, up o|
|00005ba0| 72 20 64 6f 77 6e 2c 20 | 74 68 61 74 20 79 6f 75 |r down, |that you|
|00005bb0| 20 77 61 6e 74 20 74 68 | 65 20 75 70 70 65 72 2d | want th|e upper-|
|00005bc0| 6c 65 66 74 20 63 65 6c | 6c 20 6f 66 20 74 68 65 |left cel|l of the|
|00005bd0| 20 72 65 73 75 6c 74 20 | 74 6f 20 72 65 66 65 72 | result |to refer|
|00005be0| 20 74 6f 6b 69 73 20 74 | 68 65 20 6e 75 6d 62 65 | tokis t|he numbe|
|00005bf0| 72 20 6f 66 20 63 6f 6c | 75 6d 6e 73 2c 20 74 6f |r of col|umns, to|
|00005c00| 20 74 68 65 20 6c 65 66 | 74 20 6f 72 20 72 69 67 | the lef|t or rig|
|00005c10| 68 74 2c 20 74 68 61 74 | 20 79 6f 75 20 77 61 6e |ht, that| you wan|
|00005c20| 74 20 74 68 65 20 75 70 | 70 65 72 2d 6c 65 66 74 |t the up|per-left|
|00005c30| 20 63 65 6c 6c 20 6f 66 | 20 74 68 65 20 72 65 73 | cell of| the res|
|00005c40| 75 6c 74 20 74 6f 20 72 | 65 66 65 72 20 74 6f 69 |ult to r|efer toi|
|00005c50| 69 73 20 74 68 65 20 68 | 65 69 67 68 74 2c 20 69 |is the h|eight, i|
|00005c60| 6e 20 6e 75 6d 62 65 72 | 20 6f 66 20 72 6f 77 73 |n number| of rows|
|00005c70| 2c 20 74 68 61 74 20 79 | 6f 75 20 77 61 6e 74 20 |, that y|ou want |
|00005c80| 74 68 65 20 72 65 73 75 | 6c 74 20 74 6f 20 62 65 |the resu|lt to be|
|00005c90| 2c 20 74 68 65 20 73 61 | 6d 65 20 68 65 69 67 68 |, the sa|me heigh|
|00005ca0| 74 20 61 73 20 52 65 66 | 65 72 65 6e 63 65 20 69 |t as Ref|erence i|
|00005cb0| 66 20 6f 6d 69 74 74 65 | 64 6a 69 73 20 74 68 65 |f omitte|djis the|
|00005cc0| 20 77 69 64 74 68 2c 20 | 69 6e 20 6e 75 6d 62 65 | width, |in numbe|
|00005cd0| 72 20 6f 66 20 63 6f 6c | 75 6d 6e 73 2c 20 74 68 |r of col|umns, th|
|00005ce0| 61 74 20 79 6f 75 20 77 | 61 6e 74 20 74 68 65 20 |at you w|ant the |
|00005cf0| 72 65 73 75 6c 74 20 74 | 6f 20 62 65 2c 20 74 68 |result t|o be, th|
|00005d00| 65 20 73 61 6d 65 20 77 | 69 64 74 68 20 61 73 20 |e same w|idth as |
|00005d10| 52 65 66 65 72 65 6e 63 | 65 20 69 66 20 6f 6d 69 |Referenc|e if omi|
|00005d20| 74 74 65 64 00 12 72 65 | 66 5f 74 65 78 74 2c 72 |tted..re|f_text,r|
|00005d30| 65 66 65 72 65 6e 63 65 | 00 00 14 72 65 66 65 72 |eference|...refer|
|00005d40| 65 6e 63 65 2c 72 65 6c | 5f 74 6f 5f 72 65 66 00 |ence,rel|_to_ref.|
|00005d50| 00 17 6e 61 6d 65 5f 74 | 65 78 74 2c 64 61 74 61 |..name_t|ext,data|
|00005d60| 5f 74 79 70 65 5f 6e 75 | 6d 21 6e 61 6d 65 5f 74 |_type_nu|m!name_t|
|00005d70| 65 78 74 2c 64 61 74 61 | 5f 74 79 70 65 5f 6e 75 |ext,data|_type_nu|
|00005d80| 6d 2c 72 65 66 65 72 65 | 6e 63 65 00 00 1f 66 69 |m,refere|nce...fi|
|00005d90| 6e 64 5f 74 65 78 74 2c | 77 69 74 68 69 6e 5f 74 |nd_text,|within_t|
|00005da0| 65 78 74 2c 73 74 61 72 | 74 5f 6e 75 6d 00 8b 52 |ext,star|t_num..R|
|00005db0| 65 74 75 72 6e 73 20 74 | 68 65 20 6e 75 6d 62 65 |eturns t|he numbe|
|00005dc0| 72 20 6f 66 20 74 68 65 | 20 63 68 61 72 61 63 74 |r of the| charact|
|00005dd0| 65 72 20 61 74 20 77 68 | 69 63 68 20 61 20 73 70 |er at wh|ich a sp|
|00005de0| 65 63 69 66 69 63 20 63 | 68 61 72 61 63 74 65 72 |ecific c|haracter|
|00005df0| 20 6f 72 20 74 65 78 74 | 20 73 74 72 69 6e 67 20 | or text| string |
|00005e00| 69 73 20 66 69 72 73 74 | 20 66 6f 75 6e 64 2c 20 |is first| found, |
|00005e10| 72 65 61 64 69 6e 67 20 | 6c 65 66 74 20 74 6f 20 |reading |left to |
|00005e20| 72 69 67 68 74 20 28 6e | 6f 74 20 63 61 73 65 2d |right (n|ot case-|
|00005e30| 73 65 6e 73 69 74 69 76 | 65 29 77 69 73 20 74 68 |sensitiv|e)wis th|
|00005e40| 65 20 74 65 78 74 20 79 | 6f 75 20 77 61 6e 74 20 |e text y|ou want |
|00005e50| 74 6f 20 66 69 6e 64 2e | 20 59 6f 75 20 63 61 6e |to find.| You can|
|00005e60| 20 75 73 65 20 74 68 65 | 20 3f 20 61 6e 64 20 2a | use the| ? and *|
|00005e70| 20 77 69 6c 64 63 61 72 | 64 20 63 68 61 72 61 63 | wildcar|d charac|
|00005e80| 74 65 72 73 3b 20 75 73 | 65 20 7e 3f 20 61 6e 64 |ters; us|e ~? and|
|00005e90| 20 7e 2a 20 74 6f 20 66 | 69 6e 64 20 74 68 65 20 | ~* to f|ind the |
|00005ea0| 3f 20 61 6e 64 20 2a 20 | 63 68 61 72 61 63 74 65 |? and * |characte|
|00005eb0| 72 73 35 69 73 20 74 68 | 65 20 74 65 78 74 20 69 |rs5is th|e text i|
|00005ec0| 6e 20 77 68 69 63 68 20 | 79 6f 75 20 77 61 6e 74 |n which |you want|
|00005ed0| 20 74 6f 20 73 65 61 72 | 63 68 20 66 6f 72 20 46 | to sear|ch for F|
|00005ee0| 69 6e 64 5f 74 65 78 74 | 7b 69 73 20 74 68 65 20 |ind_text|{is the |
|00005ef0| 63 68 61 72 61 63 74 65 | 72 20 6e 75 6d 62 65 72 |characte|r number|
|00005f00| 20 69 6e 20 57 69 74 68 | 69 6e 5f 74 65 78 74 2c | in With|in_text,|
|00005f10| 20 63 6f 75 6e 74 69 6e | 67 20 66 72 6f 6d 20 74 | countin|g from t|
|00005f20| 68 65 20 6c 65 66 74 2c | 20 61 74 20 77 68 69 63 |he left,| at whic|
|00005f30| 68 20 79 6f 75 20 77 61 | 6e 74 20 74 6f 20 73 74 |h you wa|nt to st|
|00005f40| 61 72 74 20 73 65 61 72 | 63 68 69 6e 67 2e 20 49 |art sear|ching. I|
|00005f50| 66 20 6f 6d 69 74 74 65 | 64 2c 20 31 20 69 73 20 |f omitte|d, 1 is |
|00005f60| 75 73 65 64 00 05 61 72 | 72 61 79 00 46 52 65 74 |used..ar|ray.FRet|
|00005f70| 75 72 6e 73 20 61 20 76 | 65 72 74 69 63 61 6c 20 |urns a v|ertical |
|00005f80| 72 61 6e 67 65 20 6f 66 | 20 63 65 6c 6c 73 20 61 |range of| cells a|
|00005f90| 73 20 61 20 68 6f 72 69 | 7a 6f 6e 74 61 6c 20 72 |s a hori|zontal r|
|00005fa0| 61 6e 67 65 2c 20 6f 72 | 20 76 69 63 65 20 76 65 |ange, or| vice ve|
|00005fb0| 72 73 61 53 69 73 20 61 | 20 72 61 6e 67 65 20 6f |rsaSis a| range o|
|00005fc0| 66 20 63 65 6c 6c 73 20 | 6f 6e 20 61 20 77 6f 72 |f cells |on a wor|
|00005fd0| 6b 73 68 65 65 74 20 6f | 72 20 61 6e 20 61 72 72 |ksheet o|r an arr|
|00005fe0| 61 79 20 6f 66 20 76 61 | 6c 75 65 73 20 74 68 61 |ay of va|lues tha|
|00005ff0| 74 20 79 6f 75 20 77 61 | 6e 74 20 74 6f 20 74 72 |t you wa|nt to tr|
|00006000| 61 6e 73 70 6f 73 65 00 | 18 65 6e 61 62 6c 65 5f |anspose.|.enable_|
|00006010| 6c 6f 67 69 63 61 6c 2c | 6d 61 63 72 6f 5f 72 65 |logical,|macro_re|
|00006020| 66 00 00 00 00 05 76 61 | 6c 75 65 00 88 52 65 74 |f.....va|lue..Ret|
|00006030| 75 72 6e 73 20 61 20 6e | 75 6d 62 65 72 20 69 6e |urns a n|umber in|
|00006040| 64 69 63 61 74 69 6e 67 | 20 74 68 65 20 64 61 74 |dicating| the dat|
|00006050| 61 20 74 79 70 65 20 6f | 66 20 61 20 76 61 6c 75 |a type o|f a valu|
|00006060| 65 3a 20 6e 75 6d 62 65 | 72 20 3d 20 31 3b 20 74 |e: numbe|r = 1; t|
|00006070| 65 78 74 20 3d 20 32 3b | 20 6c 6f 67 69 63 61 6c |ext = 2;| logical|
|00006080| 20 76 61 6c 75 65 20 3d | 20 34 3b 20 66 6f 72 6d | value =| 4; form|
|00006090| 75 6c 61 20 3d 20 38 3b | 20 65 72 72 6f 72 20 76 |ula = 8;| error v|
|000060a0| 61 6c 75 65 20 3d 20 31 | 36 3b 20 61 72 72 61 79 |alue = 1|6; array|
|000060b0| 20 3d 20 36 34 10 63 61 | 6e 20 62 65 20 61 6e 79 | = 64.ca|n be any|
|000060c0| 20 76 61 6c 75 65 00 07 | 6c 6f 67 69 63 61 6c 00 | value..|logical.|
|000060d0| 00 0f 6e 61 6d 65 5f 74 | 65 78 74 2c 76 61 6c 75 |..name_t|ext,valu|
|000060e0| 65 00 00 00 00 09 72 65 | 66 65 72 65 6e 63 65 00 |e.....re|ference.|
|000060f0| 00 13 74 79 70 65 5f 6e | 75 6d 2c 6d 61 74 63 68 |..type_n|um,match|
|00006100| 5f 74 65 78 74 00 00 00 | 00 13 74 79 70 65 5f 6e |_text...|..type_n|
|00006110| 75 6d 2c 6d 61 74 63 68 | 5f 74 65 78 74 00 00 00 |um,match|_text...|
|00006120| 00 00 00 08 74 79 70 65 | 5f 6e 75 6d 00 00 0b 78 |....type|_num...x|
|00006130| 5f 6e 75 6d 2c 79 5f 6e | 75 6d 00 6b 52 65 74 75 |_num,y_n|um.kRetu|
|00006140| 72 6e 73 20 74 68 65 20 | 61 72 63 74 61 6e 67 65 |rns the |arctange|
|00006150| 6e 74 20 6f 66 20 74 68 | 65 20 73 70 65 63 69 66 |nt of th|e specif|
|00006160| 69 65 64 20 78 2d 20 61 | 6e 64 20 79 2d 20 63 6f |ied x- a|nd y- co|
|00006170| 6f 72 64 69 6e 61 74 65 | 73 2c 20 69 6e 20 72 61 |ordinate|s, in ra|
|00006180| 64 69 61 6e 73 20 62 65 | 74 77 65 65 6e 20 2d 50 |dians be|tween -P|
|00006190| 69 20 61 6e 64 20 50 69 | 2c 20 65 78 63 6c 75 64 |i and Pi|, exclud|
|000061a0| 69 6e 67 20 2d 50 69 20 | 69 73 20 74 68 65 20 78 |ing -Pi |is the x|
|000061b0| 2d 63 6f 6f 72 64 69 6e | 61 74 65 20 6f 66 20 74 |-coordin|ate of t|
|000061c0| 68 65 20 70 6f 69 6e 74 | 20 69 73 20 74 68 65 20 |he point| is the |
|000061d0| 79 2d 63 6f 6f 72 64 69 | 6e 61 74 65 20 6f 66 20 |y-coordi|nate of |
|000061e0| 74 68 65 20 70 6f 69 6e | 74 00 06 6e 75 6d 62 65 |the poin|t..numbe|
|000061f0| 72 00 46 52 65 74 75 72 | 6e 73 20 74 68 65 20 61 |r.FRetur|ns the a|
|00006200| 72 63 73 69 6e 65 20 6f | 66 20 61 20 6e 75 6d 62 |rcsine o|f a numb|
|00006210| 65 72 20 69 6e 20 72 61 | 64 69 61 6e 73 2c 20 69 |er in ra|dians, i|
|00006220| 6e 20 74 68 65 20 72 61 | 6e 67 65 20 2d 50 69 2f |n the ra|nge -Pi/|
|00006230| 32 20 74 6f 20 50 69 2f | 32 3a 69 73 20 74 68 65 |2 to Pi/|2:is the|
|00006240| 20 73 69 6e 65 20 6f 66 | 20 74 68 65 20 61 6e 67 | sine of| the ang|
|00006250| 6c 65 20 79 6f 75 20 77 | 61 6e 74 20 61 6e 64 20 |le you w|ant and |
|00006260| 6d 75 73 74 20 62 65 20 | 66 72 6f 6d 20 2d 31 20 |must be |from -1 |
|00006270| 74 6f 20 31 00 06 6e 75 | 6d 62 65 72 00 75 52 65 |to 1..nu|mber.uRe|
|00006280| 74 75 72 6e 73 20 74 68 | 65 20 61 72 63 63 6f 73 |turns th|e arccos|
|00006290| 69 6e 65 20 6f 66 20 61 | 20 6e 75 6d 62 65 72 2c |ine of a| number,|
|000062a0| 20 69 6e 20 72 61 64 69 | 61 6e 73 20 69 6e 20 74 | in radi|ans in t|
|000062b0| 68 65 20 72 61 6e 67 65 | 20 30 20 74 6f 20 50 69 |he range| 0 to Pi|
|000062c0| 2e 20 54 68 65 20 61 72 | 63 63 6f 73 69 6e 65 20 |. The ar|ccosine |
|000062d0| 69 73 20 74 68 65 20 61 | 6e 67 6c 65 20 77 68 6f |is the a|ngle who|
|000062e0| 73 65 20 63 6f 73 69 6e | 65 20 69 73 20 4e 75 6d |se cosin|e is Num|
|000062f0| 62 65 72 3c 69 73 20 74 | 68 65 20 63 6f 73 69 6e |ber<is t|he cosin|
|00006300| 65 20 6f 66 20 74 68 65 | 20 61 6e 67 6c 65 20 79 |e of the| angle y|
|00006310| 6f 75 20 77 61 6e 74 20 | 61 6e 64 20 6d 75 73 74 |ou want |and must|
|00006320| 20 62 65 20 66 72 6f 6d | 20 2d 31 20 74 6f 20 31 | be from| -1 to 1|
|00006330| 00 1b 69 6e 64 65 78 5f | 6e 75 6d 2c 76 61 6c 75 |..index_|num,valu|
|00006340| 65 31 2c 76 61 6c 75 65 | 32 2c 2e 2e 2e 00 54 43 |e1,value|2,....TC|
|00006350| 68 6f 6f 73 65 73 20 61 | 20 76 61 6c 75 65 20 6f |hooses a| value o|
|00006360| 72 20 61 63 74 69 6f 6e | 20 74 6f 20 70 65 72 66 |r action| to perf|
|00006370| 6f 72 6d 20 66 72 6f 6d | 20 61 20 6c 69 73 74 20 |orm from| a list |
|00006380| 6f 66 20 76 61 6c 75 65 | 73 2c 20 62 61 73 65 64 |of value|s, based|
|00006390| 20 6f 6e 20 61 6e 20 69 | 6e 64 65 78 20 6e 75 6d | on an i|ndex num|
|000063a0| 62 65 72 88 73 70 65 63 | 69 66 69 65 73 20 77 68 |ber.spec|ifies wh|
|000063b0| 69 63 68 20 76 61 6c 75 | 65 20 61 72 67 75 6d 65 |ich valu|e argume|
|000063c0| 6e 74 20 69 73 20 73 65 | 6c 65 63 74 65 64 2e 20 |nt is se|lected. |
|000063d0| 49 6e 64 65 78 5f 6e 75 | 6d 20 6d 75 73 74 20 62 |Index_nu|m must b|
|000063e0| 65 20 62 65 74 77 65 65 | 6e 20 31 20 61 6e 64 20 |e betwee|n 1 and |
|000063f0| 32 39 2c 20 6f 72 20 61 | 20 66 6f 72 6d 75 6c 61 |29, or a| formula|
+--------+-------------------------+-------------------------+--------+--------+
Only 25.0 KB of data is shown above.
