ユーザーズガイド KYOSHO PITTS SPECIAL 40 PARTS LIST

[. . . ] © 2008 Apple Inc. All rights reserved. Apple Apple iPhoto Pages A iMovie Apple ppleWorks C olorSync eynote M ac M ac O S N umbers iTunes K Q uartz QuickTime Apple Inc. [. . . ] Acrobat Finder iWeb i Work Safari Apple Inc. Apple Inc. Apple Apple Apple AppleCare Adobe A dobe Systems Incorporated A pple Apple 1 Infinite Loop Cupertino, CA 95014-2084 U. S. A. www. apple. com 163-1480 3 20 www. apple. com/jp J019-1277 06/2008 2 1 1 16 18 18 20 21 21 21 22 22 23 24 25 25 26 28 28 29 29 30 31 31 31 33 33 34 34 35 35 35 36 Numbers Numbers Numbers 2 Numbers 3 36 36 37 37 38 38 39 39 40 41 41 42 42 42 43 3 44 44 45 45 45 48 48 49 49 50 51 51 51 52 52 53 54 54 55 56 57 57 58 59 60 61 N umbers iWork 4 62 63 63 64 65 67 68 68 69 69 69 70 70 71 72 72 73 73 74 74 74 75 75 76 77 77 78 4 79 79 80 80 80 81 81 82 82 82 83 83 84 1 5 5 86 87 87 88 88 88 89 89 90 90 90 91 91 92 93 93 94 94 95 95 96 6 98 98 101 102 103 103 103 104 104 104 105 105 105 106 106 107 107 107 108 108 1 6 109 109 109 110 111 112 113 113 113 113 113 114 114 114 115 115 115 116 116 116 117 118 7 119 119 119 120 120 121 121 121 121 122 122 122 123 123 124 124 125 125 125 2D 3D 7 126 126 126 126 127 128 128 129 129 130 131 131 132 133 133 133 134 135 135 135 136 136 136 137 137 137 138 139 140 141 141 141 142 143 143 143 144 144 145 145 146 Web 8 146 146 147 148 8 149 149 150 150 150 151 151 151 152 152 153 153 154 154 154 155 156 156 158 158 159 159 160 160 160 161 162 164 164 164 165 166 166 167 167 168 168 9 168 169 169 170 171 171 172 172 173 173 173 174 176 177 177 177 178 9 179 179 180 182 182 183 183 184 185 186 187 188 188 188 189 189 189 190 190 191 191 191 PDF Numbers 10 ColorSync iWeb 11 Numbers 1 2 3 4 10 192 192 12 193 193 195 196 198 198 199 200 201 202 204 205 205 205 206 206 207 207 208 208 209 209 209 210 210 210 211 211 212 212 213 213 214 214 215 215 216 216 217 5 ABS ACCRINT ACCRINTM ACOS ACOSH ADDRESS AND AREAS ASIN ASINH ATAN ATAN2 ATANH AVEDEV AVERAGE AVERAGEA CEILING CHAR CHOOSE CLEAN CODE COLUMN COLUMNS COMBIN CONCATENATE CONFIDENCE CORREL 11 217 218 218 219 220 220 221 221 222 223 224 224 225 226 226 227 227 228 228 229 229 230 230 230 231 231 232 232 233 233 234 234 235 236 236 237 237 238 238 239 240 COS COSH COUNT COUNTA COUNTBLANK COUNTIF COUPDAYBS COUPDAYS COUPDAYSNC COUPNUM COVAR DATE DATEDIF DAY DB DDB DEGREES DISC DOLLAR EDATE EVEN EXACT EXP FACT FALSE FIND FIXED FLOOR FORECAST FV GCD HLOOKUP HOUR HYPERLINK IF INDEX INDIRECT INT INTERCEPT IPMT IRR 12 240 241 241 241 242 242 243 244 244 244 245 245 245 246 246 247 248 248 248 249 249 250 250 250 251 251 252 252 253 253 254 254 255 255 256 256 257 257 258 258 259 ISBLANK ISERROR ISEVEN ISODD ISPMT LARGE LCM LEFT LEN LN LOG LOG10 LOOKUP LOWER MATCH MAX MAXA MEDIAN MID MIN MINA MINUTE MIRR MOD MODE MONTH MROUND NOT NOW NPER NPV ODD OFFSET OR PERCENTILE PI PMT POISSON POWER PPMT PRICE 13 260 260 261 262 262 262 263 263 264 264 264 265 266 266 267 267 268 268 269 270 270 270 271 271 271 272 272 273 273 274 274 275 275 276 277 277 278 278 279 279 280 PRICEDISC PRICEMAT PROB PRODUCT PROPER PV QUOTIENT RADIANS RAND RANDBETWEEN RANK RATE REPLACE REPT RIGHT ROMAN ROUND ROUNDDOWN ROUNDUP ROW ROWS SEARCH SECOND SIGN SIN SINH SLN SLOPE SMALL SQRT STDEV STDEVA STDEVP STDEVPA SUBSTITUTE SUM SUMIF SUMPRODUCT SUMSQ SYD T 14 280 281 281 282 282 283 283 283 284 284 284 285 286 286 287 288 289 289 TAN TANH TIME TIMEVALUE TODAY TRIM TRUE TRUNC UPPER VALUE VAR VARA VARP VARPA VDB VLOOKUP WEEKDAY YEAR 290 15 Numbers PDF ’ umbers N ’ N umbers Numbers Numbers 16 Numbers umbers N 18 1 Numbers Numbers 31 2 Numbers 44 3 4 5 79 83 1 98 6 Numbers 119 149 7 8 179 9 1 0 1 1 1 2 N umbers N umbers 183 Web i 188 N umbers 193 Numbers 17 1 Numbers 1 N umbers Numbers Numbers Dock Finder 18 2006 1 2007 1 umbers N 19 umbers N Numbers  Numbers    20 1 umbers N  24   m m N umbers 37 1 umbers N 21 PDF 39 52 1 22 1 umbers N 1 7 9 1 umbers N 23 Numbers Numbers 1 2 3  C ontrol  24 1 umbers N m umbers N 10 uickTime Q 1 umbers N 25 m m m Option 2 N umbers  = 8 8  90 26 1 umbers N  S UM AVERAGE 96 1 umbers N 27 i Photo i Tunes iTunes Aperture i Photo m m Mac OS X m 61 1 28 1 umbers N Mac OS X m 1 23 Numbers Numbers 1 1 umbers N 29 Numbers Numbers m Control 30 1 umbers N 2 Numbers 2 Numbers Numbers Microsoft Excel Numbers Numbers Numbers AppleWorks 6 PDF Numbers Microsoft Excel ppleWorks A Numbers Numbers 1 31 1 Dock Numbers Finder N umbers 2 3 Numbers Numbers Numbers [ ] 32 2 umbers N Numbers Microsoft Excel Numbers OFX O pen Financial Exchange A ppleWorks 6 CSV AppleWorks m Numbers m m 179 N umbers N umbers Numbers Numbers Microsoft Excel 1 86 P DF CSV Numbers m m Numbers m Finder Numbers Numbers umbers N onts F ac M 2 umbers N 33 Numbers N umbers F onts Numbers S 1 2 3 4 5 S N umbers 6 N umbers Numbers Windows Windows Mac O S X ac OS 9 M indows W Macintosh AFP Numbers 186 34 2 umbers N iWeb iWeb 1 87 m m m m 1 m Numbers 1 m m 88 1 2 umbers N 35 Numbers 1 2 Spotlight Spotlight Spotlight Spotlight m Numbers N umbers m N umbers 36 2 umbers N 1 1 38 Numbers m m 2 umbers N 37 m m m 39 Delete m m m 1 9 3 38 2 umbers N m m 4 9 107 PDF 2 umbers N 39 m m m 1 2 40 2 umbers N 1 2 3 4 1 45 m m 48 107 54 1 m 2 umbers N 41 m 1 2 PDF m 1 2 3 4 5 1 45 42 2 umbers N 1 2 3 4 5 2 umbers N 43 3 3    79 3 8 Numbers 4 5 98 6  45  51  54  69  74  77 44 Numbers m 49 m m O ption 5 1 m O ption Numbers m 3 45 m Return Tab 1 5 m 46 3 m 79 m 1 1 9 1 m m Control m 88 90 96 m 3 47 m 51 Shift Option m m 3 7 m m Shift 45 48 3 m m Option Numbers 1 2 m 2 m m m 1 2 1 0 8 1 8 7 3 49 3 4 8 6 9 7 4 74 73 5 4 4 5 6 7 2 8 OK 1 88 iWork iWork N umbers  Numbers  Numbers 50 3 iWork 1 51 2 3 m m Return 1 2 3 51 T ab Return Return Tab Tab Tab Tab Tab Tab ab T 2 Shift Tab Shift Tab Shift Tab Return Tab Return Tab Return Return Shift 2 Return m 1 Shift m 52 3 1 2 1 1 1 m 1 3 53 m 1 1 1 Shift 1 hift S m m hift S 51 54 3 m Return m m D elete R eturn Enter m m 8 3 75 96 m m C ontrol Return Return Return Option Return m Option m Tab 3 55 m m m m 64 146 1 48 m m % m 0 9 58 + - (, ) / $ % . ?d e f C LEAN C LEAN(A1) a b c d e f 12 213 CODE CODE CODE( Unicode )  CODE CHAR ODE("A") C A a a A3 1488 f 65 97 C ODE("abc") HAR(97) C C ODE(A3) ODE(" ") C 102 COLUMN COLUMN C OLUMN COLUMN([ ])  C OLUMN(B7) OLUMN() C 2 B 2 214 12 COLUMNS COLUMNS COLUMNS( )  Numbers OLUMNS(B3:D10) C 3 B C D 3 C OLUMNS(5:5) 5 COMBIN COMBIN COMBIN( , )   1, ( 2, 3) (3, 2, 1) OMBIN(3, 2) C 3 OMBIN(3. 2, 2. 3) C 3 3 3 2 C OMBIN(5, 2) COMBIN(5, 3) 10 12 215 CONCATENATE CONCATENATE CONCATENATE( , , [ , . . . ])    & 1 2 3 A1 1 B abc ONCATENATE(B1, ", ", A1) C I psum, Lorem ONCATENATE("a", "b", "c") C "a" & "b" & "c" abc CONFIDENCE CONFIDENCE CONFIDENCE( , , ) 1 = 0. 05  0. 95 95%   ONFIDENCE(0. 05, 1, 10) C 99. 38 100. 62 ONFIDENCE(0. 1, 1, 10) C 99. 48 100. 52 ONFIDENCE(0. 05, 1, 20) C 0. 62 0. 52 0. 44 0. 36 0. 31 100 100 95% 90% C ONFIDENCE(0. 05, 1, 30) ONFIDENCE(0. 05, 1, 40) C 216 12 CORREL CORREL CORREL( 2 , y x )   C ORREL(D2:D7, E2:E7) ORREL(B2:B7, A2:A7) C 1 0. 977265 COS COS COS( )  RADIANS 2 P I 3 4 OS(1) C 0. 540302306 0. 5 /3 0. 5 -1 1 57. 3 C OS(RADIANS(60)) OS(P1()/3) C 60 0 6 C OS(PI()) 180 12 217 COSH COSH COSH( )  OSH(0) C 1 1. 543 74. 21 11, 013. 233 C OSH(1) OSH(5) C C OSH(10) COUNT COUNT COUNT( , [ , ])  1 OUNTA C OUNT(A1:E1) C 5 0 3 0 2 2 C OUNT(A2:E2) OUNT(A3:E3) C C OUNT(A4:E4) OUNT(A5:E5) C C OUNT(1, SUM(4, 5)) 218 12 COUNTA COUNTA COUNTA( , [ , 1 C OUNT ] )  C OUNTA(A1:E1) OUNTA(A2:E2) C 5 5 5 5 2 4 2 C OUNTA(A3:E3) OUNTA(A4:E4) C C OUNTA(A5:E5) OUNTA(1, "a", TRUE, FALSE) C C OUNTA(1, SUM(4, 5)) 12 219 COUNTBLANK COUNTBLANK COUNTBLANK( )  C OUNTBLANK(A1:E1) OUNTBLANK(A2:E2) C 0 1 2 1 5 C OUNTBLANK(A3:E3) OUNTBLANK(A4:E4) C C OUNTBLANK(A5:E5) COUNTIF COUNTIF COUNTIF( , RUE T )   FALSE 95 1 2 3 4 5 6 7 8 A1:A8 OUNTIF(A1:A8, "<4") 3 C C OUNTIF(A1:A8, ">4") OUNTIF(A1:A8, ">=4") C 4 5 220 12 COUPDAYBS COUPDAYBS COUPDAYNC( , , , [ ])    1 2 4 1 2 4 0 1 2 3 4 30E 30  360 30 1 1 360 360 365 360 365 360 30 360 A1:A4 /1/2000 1 /1/2001 9 4 1 62 7 60 3 7 1 7 4 8 31 30 7 1 C OUPDAYBS(A1, A2, A3, A4) 9 1 C OUPDAYBS(A1, A2, A3, 0) OUPDAYBS(DATE(2000, 7, 4), A2, 2, 0) C COUPDAYS COUPDAYS COUPDAYS( , , , [ ])    1 2 1 2 12 221 4 4 30  0 1 2 3 4 30E 360 30 1 1 360 360 365 360 365 360 30 360 A1:A4 /1/2000 1 /1/2001 9 4 0 OUPDAYS(A1, A2, A3, A4) C 90 92 7 7 8 8 9 9 30 360 360 C OUPDAYS(A1, A2, A3, 1) OUPDAYS(A1, A2, A3, 2) C 90 91. 25 90 7 8 7 7 9 8 8 9 9 C OUPDAYS(A1, A2, A3, 3) C OUPDAYS(A1, A2, A3, 4) 365 3 0E/360 COUPDAYSNC COUPDAYSNC COUPDAYNC( , , , [ ])    1 2 4 1 2 4 0 1  30 360 30 360 222 12 2 3 4 30E 360 365 360 30 1 1 360 365 360 A1:A4 /1/2000 1 /1/2001 9 4 1 30 C OUPDAYSNC(A1, A2, A3, A4) 30 9 9 61 9 30 60 1 10 1 C OUPDAYSNC(DATE(2000, 8, 1), A2, A3, A4) 31 10 1 8 C OUPDAYSNC(DATE(2000, 8, 1), A2, A3, 0) 30 10 1 8 8 1 1 COUPNUM COUPNUM COUPNUM( , , , [ ])    1 2 4 1 2 4 0 1 2 3 4 30E 30  360 30 1 1 360 360 365 360 365 360 30 360 12 223 A1:A4 2 4 0 /1/2000 1 /1/2001 4 3 2 1 C OUPNUM(A1, A2, A3, A4) OUPNUM(DATE(2000, 6, 1), A2, A3, A4) C C OUPNUM(DATE(2000, 9, 1), A2, A3, A4) OUPNUM(DATE(2000, 11, 1), A2, A3, A4) C COVAR COVAR COVAR( 2 , 1 2 )   1 2 2 1 C 3:H3 3. 4 3 . 7 4 4. 4 . 4 5. 1 5 2. 1 3 5. 5 6 7. 2 . 3 4. 5 . 4 OVAR(C3:H3, C2:H2) 1. 234 C 2 C 2:H2 DATE DATE DATE( 1 , , )    1 0 10 1910 2010 D ATE(1959, 2, 14) 1959 2 14 224 12 DATEDIF DATEDIF DATEDIF( 2 , ) ,    D M Y MD YM YD A1 4/6/88 A2 6781 222 18 24 6 207 10/30/06 1988 1988 1988 4 4 4 4 6 4 6 6 6 6 2006 2006 2006 30 10 10 30 10 10 10 30 30 30 ATEDIF(A1, A2, "D") D D ATEDIF(A1, A2, "M") ATEDIF(A1, A2, "Y") D D ATEDIF(A1, A2, "MD") ATEDIF(A1, A2, "YM") D D ATEDIF(A1, A2, "YD") ATEDIF(A1, NOW(), "Y") & " years, " & DATEDIF(A1, NOW(), "YM") & " months, and " & D 1 DATEDIF(A1, NOW(), "MD") & " days" 988 4 6 12 225 DAY DAY DAY( ) Numbers  AY("4/6/88 11:59:22 AM") D 6 DB DB DB( , , , , [ ])      12 A2:E2 1000 1 4 1 12 00 $438 $246. 16 $138. 34 $77. 75 $328. 50 $219 $109. 50 D B(A2, B2, C2, D2, E2) B(A2, B2, C2, 2, E2) D D B(A2, B2, C2, 3, E2) B(A2, B2, C2, 4, E2) D D B(A2, B2, C2, D2, 9) B(A2, B2, C2, D2, 6) D D B(A2, B2, C2, D2, 3) 226 12 DDB DDB DDB( , , , , [ ])      2 DB(1000, 100, 4, 1) D $500 $250 $125 $25 $250 $750 $150 $0 D DB(1000, 100, 4, 2) DB(1000, 100, 4, 3) D D DB(1000, 100, 4, 4) DB(1000, 100, 4, 1, 1) D D DB(1000, 100, 4, 1, 3) DB(1000, 100, 4, 2, 3) D D DB(1000, 100, 4, 3, 3) DEGREES DEGREES DEGREES( )  EGREES(PI()) D 180 57. 2957795130823 = 180 1 D EGREES(1) 12 227 DISC DISC DISC( , , , , [ ])      0 1 2 3 4 30E 100 100 30 360 30 1 1 360 360 365 360 365 360 30 360 A1:E1 /1/2001 1/1/2000 1 90 100 0 10% 20% 18% ISC(A1, B1, C1, D1, E1) D D ISC(A1, B1, 80, D1, E1) ISC(A1, B1, C1, 110, E1) D DOLLAR DOLLAR DOLLAR( , [ ])   2 DOLLAR 1 5 228 12 D OLLAR(2323. 124) OLLAR(2323. 125) D $2, 323. 12 $2, 323. 13 $100 ($12. 000) $120 $12. 000 D OLLAR(99. 554, 0) OLLAR(12, 3) D D OLLAR(-12, 3) OLLAR(123, -1) D EDATE EDATE EDATE( , )   DATE("1/15/2000", 1) E 2/15/2000 1/15/1998 1 24 E DATE("1/15/2000", -24) EVEN EVEN EVEN( 0 )  DD O VEN(1) E 2 2 4 -4 0 E VEN(2) VEN(2. 5) E E VEN(-2. 5) VEN(0) E 12 229 EXACT EXACT EXACT( , ) TRUE   XACT("toledo", "toledo") E TRUE FALSE TRUE E XACT("Toledo", "toledo") XACT(toledo", "tol" & "edo") E EXP EXP EXP( e )  E XP(1) XP(LN(5)) E 2. 71828182845905 5 XP E LN e FACT FACT FACT( )  ACT(5) F 120 1 24 F ACT(0) ACT(4. 5) F 1 2 3 4 !4 5 F ACT(-1) 230 12 FALSE FALSE f alse FALSE() FALSE FALSE  FALSE() F ALSE ALSE() F FALSE FALSE A ND(1, FALSE()) FIND FIND FIND( , , [ ])    SEARCH IND("e", "where on earth") F 3 10 8 where on earth 3 e F IND("e", "where on earth", 8) arth e e on n 12 231 FIXED FIXED FIXED( , [ ], [ ])    FALSE TRUE 1 0 IXED(6789. 123, 2) F , 789. 12 6 F IXED(6789. 123, 1, 1) IXED(6789. 123, -2) F 6789. 1 6, 800 F IXED(12. 4, 0) IXED(12. 5, 0) F 1 2 3 1 F IXED(4, -1) IXED(5, -1) F 0 10 FLOOR FLOOR FLOOR( 0 , )   0 C EILING ROUNDUP R INT R OUND OUNDDOWN TRUNC 232 12 LOOR(0. 25, 1) F 0 1 4 70 0 7. 5 F LOOR(1. 25, 1) LOOR(5, 2) F F LOOR(73, 10) LOOR(-0. 25, -1) F F LOOR(9, 2. 5) FORECAST FORECAST FORECAST( , , y x ) x    y SLOPE INTERCEPT ORECAST(9, A3:F3, A2:F2) F 19 FV FV FV FV( F uture Value , , [ ], [ ], [ ])   12 233    0 1 V(5%, 10, -300, -3000, 0) F 5% 3000 $8660. 05 -300 2 10 GCD GCD GCD( , [ 1 , ] )  0 G CD(8, 10) G CD(34, 51) 2 3 17 CD(99, 102, 105) G HLOOKUP HLOOKUP 1 HLOOKUP( , , , [ ])   234 12   TRUE 1 FALSE 1 0 H LOOKUP(20, A1:E4, 2) LOOKUP(39, A1:E4, 2) H E E H LOOKUP("M", A2:E4, 2) LOOKUP("C", A2:E3, 2) H d olor orem l H LOOKUP("blandit", A3:E4, 2) LOOKUP("C", A2:E4, 3, TRUE) H 5 1 H LOOKUP("C", A2:E4, 3, FALSE) HOUR HOUR 23 HOUR( 0 23 2 4 0 ) Numbers  OUR(NOW()) H H OUR("4/6/88 11:59:22 AM") 11 12 235 HYPERLINK HYPERLINK W eb HYPERLINK( , [ ])   Universal Resource Locator URL U RL YPERLINK("http://www. apple. com", "Apple") H Web Web YPERLINK("mailto:janedoe@example. com?subject=Quote Request", "Get Quote") H janedoe@example. com IF IF IF( TRUE , [ ], [ ]) FALSE 2 1   TRUE  FALSE 0 FALSE 1 TRUE I F(A5>=0, "Nonnegative", "Negative") egative N I F(AND(A8, A9), 1, 0) 0 AND 0 A5 0 N onnegative A9 A8 1 1 236 12 INDEX INDEX INDEX( , [ ], [ ], [ ])     1 1 I NDEX(B2:E5, 1, 1) I NDEX(B2:E5, 3, 2) I NDEX(B2:E5, 2, 3) I NDEX(B2:E5, 1, 5) 2 1024 128 4 INDIRECT INDIRECT INDIRECT( , [ ])   TRUE FALSE 1 0 R1C1 A 1 12 237 A1 99 A20 99 I NDIRECT(A20) A1 A1 INT INT INT( )  ROUNDUP R INT R OUND OUNDDOWN TRUNC I NT(1. 49) I NT(1. 50) I NT(1. 23456) I NT(1111. 222) I NT(-2. 2) I NT(-2. 8) 1 1 1 1111 -3 -3 INTERCEPT INTERCEPT INTERCEPT( y , y x SLOPE ) x y   238 12 I NTERCEPT(A2:F2, A1:F1) LOPE(A2:F2, A1:F1) S 2 1 2. 392 I NTERCEPT(A5:F5, A4:F4) IPMT IPMT IPMT( , , , , [ ], [ ])       0 1 0 10% 0. 1/12 1 0. 00833 12% 12 -$10 1000 1 I PMT(0. 12/12, 1, 12, 1000) 12 239 IRR IRR 0 IRR( , [ ])   10% A1:F1 1000 0 1 050 50 50 50 5 000 1 4 8, 000 5 2, 000 8000 8000 1 A1:A6 -20000 8000 8 000 0000 30. 06% 50 5% I RR(A1:F1) 5 1050 20, 000 RR(A1:A6) I ISBLANK ISBLANK ISBLANK( TRUE FALSE )  I SBLANK(A1) I SBLANK(B2) TRUE FALSE 240 12 ISERROR ISERROR TRUE FALSE ) ISERROR(  A1 =QUOTIENT(3, 0) TRUE 0 I SERROR(A1) ISEVEN ISEVEN ISEVEN( 2 T RUE F ALSE )  I SEVEN(2) I SEVEN(2. 75) I SEVEN(3) TRUE TRUE FALSE ISODD ISODD 2 ) TRUE FALSE ISODD(  12 241 I SODD(3) I SODD(3. 75) I SODD(2) TRUE TRUE FALSE ISPMT ISPMT ISPMT( , , , )     IPMT 10% 0. 1/12 1 0. 00833 12% 12 -$10 1000 1 I PMT(0. 12/12, 1, 12, 1000) LARGE LARGE LARGE( 1 , ) 1 2   n 0 242 12 L ARGE(A2:E2, 1) ARGE(A2:E2, 2) L 1 2 50 40 10 n L ARGE(A2:E2, 5) ARGE(A2:E2) L 5 n 5 L ARGE(A2:E2, 0) ARGE(A2:E2, 6) L 0 6 LCM LCM LCM( , [ 0 , 1 ])  L CM(2, 3) CM(34, 68) L 6 68 120 120 L CM(30, 40, 60) L CM(2, -3) CM(30. 25, 40. 333, 60. 5) L 12 243 LEFT LEFT LEFT( , [ ]) 1   EFT("one two three", 2) L n o L EFT("abc") a LEN LEN LEN( )  EN("12345") L 5 15 6 3 L abc def " EN(" ) LN LN e ) LN(  L N(2. 71828) N(EXP(1)) L 1 1 N L e EXP 1 2. 71828 244 12 LOG LOG LOG( , [ ]) 1   10 OG(8, 2) L 3 L OG(100, 10) OG(5. 0625, 1. 5) L L OG(100) 4 2 LOG10 LOG10 LOG10( 10 )  10 LOG L OG10(1) OG10(10) L 0 1 2 3 L OG10(100) OG10(1000) L LOOKUP LOOKUP LOOKUP( , , [ )    12 245 L OOKUP("C", A1:F1, A2:F2) OOKUP(40, A2:F2, A1:F1) L 30 D 50 L OOKUP("B", A1:C1, D2:F2) LOWER LOWER LOWER( )  OWER("UPPER") L pper u L OWER("Lower") OWER("MiXeD") L l ower mixed MATCH MATCH 1 MATCH( , 1 , [ 1 ])    1 0 -1 246 12 MATCH 1 2 M ATCH(40, A1:A5) ATCH(40, E1:E5) M 4 1 3 1 M ATCH(35, E1:E5, 1) ATCH(35, E1:E5, -1) M 3 0 40 3 5 35 M ATCH(35, E1:E5, 0) MAX MAX MAX( , [ , ) ]  M AX(5, 5, 5, 5, 6) AX(1, 2, 3, 4, 5) M 6 5 12 247 MAXA MAXA 1 MAXA( FALSE , [ , ]) 0 T RUE  AXA(1, 2, 3, 4) M 4 A1:C1 -1 10 0 M AXA(A1:C1) MEDIAN MEDIAN MEDIAN( , [ , ])  2 EDIAN(1, 2, 3, 4, 5) M 3 3. 5 5 M EDIAN(1, 2, 3, 4, 5, 6) EDIAN(5, 5, 5, 5, 6) M MID MID MID( , , ) 1    248 12 M ID("lorem ipsum dolor sit amet", 7, 5) ID("1234567890", 4, 3) M 56 4 ipsum M ID("shorten", 5, 20) t en MIN MIN MIN( , [ , ])  M IN(5, 5, 5, 5, 6) IN(1, 2, 3, 4, 5) M 5 1 MINA MINA 1 MINA( FALSE , [ , 0 ] ) 0 T RUE  M INA(1, 2, 3, 4) INA(A1:C1) M 1 A1:C1 A1:C1 -1 10 -10 M INA(A1:C1) 10 1 0 12 249 MINUTE MINUTE MINUTE( ) Numbers  INUTE("4/6/88 11:59:22 AM") M 59 MIRR MIRR M odified Internal Rate of Return MIRR( MIRR , ) ,    M IRR({-5000, 2000, 4000, -2000, 5000}, 0. 1, 0. 15) 19. 66% MOD MOD MOD( , 0 )   M OD MOD(a, b) MOD(a, b) a = bk + r 0 r k b r a - b * INT(a / b) 250 12 M OD(6, 3) OD(7, 3) M 0 1 2 1 0. 5 0. 25 M OD(8, 3) OD(-8, 3) M M OD(4. 5, 2) OD(7, 0. 75) M MODE MODE MODE( , [ , ])  2 ODE(5, 5, 5, 5, 6) M 5 2 6 M ODE(1, 2, 3, 4, 5) ODE(2, 2, 4, 6, 6) M M ODE(6, 6, 4, 2, 2) MONTH MONTH MONTH( ) Numbers  ONTH("April 6, 1988 11:59:22 AM") M 4 12 251 MROUND MROUND MROUND( , )   0 ROUND(2, 3) M 3 3 3 6 M ROUND(4, 3) M ROUND(4. 5, 3) ROUND(-4. 5, 3) M ROUND(4. 4999, 3) M NOT NOT FALSE TRUE ) NOT(  0 FALSE TRUE N OT(0) 0 FALSE A9 NOR TRUE TRUE R(A9, NOT(A9)) O N OT(OR(FALSE, FALSE)) TRUE O R 252 12 NOW NOW NOW()  6 2 TODAY 12:00 2008 10 4 OW() N ctober 4, 2008 10:47 AM O NPER NPER NPER( , 1 , , [ ], [ ])      0 1 0 10% 0. 1/12 0. 00833 1 12 253 N PER(0. 1/12, -100, 1000) 1, 000 10. 5 1 1 10% 100 NPV NPV NPV( , : , [ , . . . ])   PV(10%, -5000, 0, 10000, 10000, 10000) N 1 0% 5, 000 10, 000 $16007. 04 4 0 10, 000 10, 000 ODD ODD ODD( 0 )  E VEN O DD(1) DD(2) O 1 3 3 -3 1 O DD(2. 5) DD(-2. 5) O O DD(0) 254 12 OFFSET OFFSET 1 , , , [ ], [ ]) 0 0 OFFSET(      1 1 FFSET(A1, 5, 5) O F6 G33 A1 F33 5 5 O FFSET(G33, 0, -1) OR OR OR( 1 , [ , ) ] TRUE FALSE  0 FALSE TRUE R(A1+A2<100, B1+B2<100) O 100 TRUE R(5, 0, 6) O 0 RUE T 100 FALSE 12 255 PERCENTILE PERCENTILE PERCENTILE( , )   P ERCENTILE(A2:E2, 0. 5) ERCENTILE(A4:E4, 0. 5) P 80 90 50% 50% PI PI PI() 15  I() P 3. 14159265358979 1 S IN(PI()/2) /2 9 0 256 12 PMT PMT PMT( , , , [ ], [ ])     0  0 1 P PMT IPMT MT(10%/12, 36, 10000, 0) P 10% 36 -$322. 67 2, 000 1 322. 67 2, 000 POISSON POISSON POISSON( , , )    TRUE FALSE 12 257 10 8 0. 112599 P OISSON(8, 10, FALSE) POWER POWER POWER( ^ , )   ^ OWER(2, 3) P 2^3 P OWER(2, 3) OWER(2, 10) P 8 1024 0. 125 10 P OWER(0. 5, 3) OWER(100, 0. 5) P PPMT PPMT PPMT( , , , , [ ], [ ])       0 1 0 258 12 10% 1 0. 1/12 0. 00833 12% 12 -$78. 85 1000 1 PMT(0. 12/12, 1, 12, 1000) P PRICE PRICE PRICE( $100 , , , , , , [ ])       1 2 4 100 1 2 4 0 1 2 3 4 30E 30  360 30 1 1 360 360 365 360 365 360 30 360 A1:F1 1 0. 05 0 2 /1/2000 1 /1/2001 . 1 1 00 9 5. 35157 PRICE(A1, A2, A3, A4, A5, A6) 12 259 PRICEDISC PRICEDISC PRICEDISC( , , , , [ ])      0 1 2 3 4 30E 30 100 360 30 1 1 360 360 365 360 365 360 30 360 A1:D1 1/1/2000 1/1/2001 0 . 1 100 90 RICEDISC(A1, B1, C1, D1) P PRICEMAT PRICEMAT PRICEMAT( , , , , , [ ])       0 1 2 3 4 30E 30 100 360 30 1 1 360 360 365 360 365 360 30 360 260 12 A1:E1 1/1/2000 1 /1/2010 1/1/1999 0 . 1 0 . 1 95 P RICEMAT(A1, B1, C1, D1, E1) PROB PROB PROB( , , , [ ]) 1     ROB(A1:A10, C1:C10, 4, 6) P 0. 3 0. 5 0. 59 0. 21 4 5 6 5 4 5 6 6 P ROB(A1:A10, C1:C10, 5, 9) ROB(A1:A10, E1:E10, 4, 6) P P ROB(A1:A10, E1:E10, 6) 12 261 PRODUCT PRODUCT PRODUCT( , [ , . . . ])  1 RODUCT(2, 4) P 8 50 P RODUCT(0. 5, 5, 4, 5) PROPER PROPER PROPER( )  ROPER("lorem ipsum") P "Lorem Ipsum" "Lorem’s Ip-Sum" "1A23 B456" P ROPER("lorem’s ip-sum") ROPER("1a23 b456") P PV PV PV PV( P resent Value ], [ ], [ ]) , , [    262 12  0  0 1 V(10%, 5, -100, 5000) P -$2725. 53 5, 000 100 10% 5 $2, 725. 53 QUOTIENT QUOTIENT QUOTIENT( 2 ) ,   Q UOTIENT(5, 2) UOTIENT(-5, 2) Q 2 -2 2 3 0 Q UOTIENT(5. 99, 2) UOTIENT(6, 2) Q Q UOTIENT(5, 6) RADIANS RADIANS RADIANS( )  R ADIANS(90) 1. 5708 1 9 0 1. 5708 1 57. 296 ADIANS(57. 2957795130823) R 12 263 RAND RAND RAND() 0 1  AND() R 4 0. 67 . 9 0. 12 0. 8 0 RANDBETWEEN RANDBETWEEN RANDBETWEEN( , )   R ANDBETWEEN(1, 10) 2 9 7 3 9 RANK RANK RANK( , , [ ])    0 0 1 1 264 12 1 2 2 3 R ANK(20, A2:E8) ANK(20, A2:E2) R 7 4 2 5 4 6 4 2 0 1 50 1 1 R ANK(20, A2:E2, 1) ANK(10, A4:E4) R 10 R ANK(4, A6:E7, 1) ANK(5, A6:E7, 1) R RATE RATE 0 RATE( ], , [ ], [ ], [ ]) , [      0 1 0 12 265  10% ATE(10*12, , -5000, 20000) R 5 , 000 10 1. 16% 20, 000 12 4 1. 16% 13. 9% REPLACE REPLACE 2 , , , ) REPLACE(     R EPLACE("received applicant's forms", 10, 9, "Frank") "received Frank's forms" REPT REPT REPT( , )   R EPT("*", 5) EPT("ha", 3) R "*****" "hahaha" 266 12 RIGHT RIGHT RIGHT( , [ ]) 1   IGHT("one two three", 2) R "ee" R IGHT("abc") "c" ROMAN ROMAN ROMAN( , [ ) ] 0 4000 10 10 2 999 10 XMIX 3 6 999 XMIX 999 LMVLIV MXCIX C   : RUE 0 T LMVLIV 1 2 1 VMIV 3 2 6 4 999 VMIV M I FALSE 6 999 I M 12 267 R OMAN(12) OMAN(999) R XII CMXCIX LMVLIV XMIX VMIV IM R OMAN(999, 1) OMAN(999, 2) R R OMAN(999, 3) OMAN(999, 4) R ROUND ROUND ROUND( , )   ROUNDUP R INT R OUND OUNDDOWN TRUNC OUND(1. 49, 0) R 1 2 1. 235 1100 -2 -3 R OUND(1. 50, 0) OUND(1. 23456, 3) R R OUND(1111. 222, -2) OUND(-2. 2, 0) R R OUND(-2. 8, 0) ROUNDDOWN ROUNDDOWN ROUNDDOWN( 0 , )   268 12 ROUNDUP R INT R OUND OUNDDOWN TRUNC OUNDDOWN(1. 49, 0) R 1 1 1. 234 1100 -2 -2 R OUNDDOWN(1. 50, 0) OUNDDOWN(1. 23456, 3) R R OUNDDOWN(1111. 222, -2) OUNDDOWN(-2. 2, 0) R R OUNDDOWN(-2. 8, 0) ROUNDUP ROUNDUP ROUNDUP( 0 , )   INT R OUND OUNDDOWN TRUNC ROUNDUP R OUNDUP(1. 49, 0) R 2 2 1. 235 1200 -3 -3 R OUNDUP(1. 50, 0) OUNDUP(1. 23456, 3) R R OUNDUP(1111. 222, -2) OUNDUP(-2. 2, 0) R R OUNDUP(-2. 8, 0) 12 269 ROW ROW ROW([ ])  OW(B7) R 7 B7 7 R OW() ROWS ROWS ROWS( )  Numbers OWS(A11:D20) R 10 1 1 20 10 R OWS(D:D) D SEARCH SEARCH SEARCH( 1 , , [ ]) * 2    ? 1 270 12 S EARCH("ra", "abracadabra") S EARCH("ra", "abracadabra", 5) 10 3 10 "ra" "ra" " abracadabra" 5 3 SECOND SECOND SECOND( ) Numbers  ECOND("4/6/88 11:59:22 AM") S 22 SIGN SIGN SIGN( 1 ) -1 0  S IGN(2) IGN(0) S 1 0 -1 A4 -2 1 - S IGN(-2) IGN(A4) S SIN SIN SIN( )  RADIANS P I SIN 12 271 S IN(1) S IN(PI()/2) 0. 841470985 0. 5 1 1 30 57. 3 IN(RADIANS(30)) S /2 9 0 SINH SINH SINH( )  S INH(0) INH(1) S 0 1. 175 74. 203 11013. 233 S INH(5) INH(10) S SLN SLN SLN( , , )    S LN(10000, 1000, 6) 1 $1500 1 0, 000 6 1, 000 272 12 SLOPE SLOPE SLOPE( , )   INTERCEPT S LOPE(A2:F2, A1:F1) S LOPE(A5:F5, A4:F4) 2 1 0. 402 I NTERCEPT(A2:F2, A1:F1) SMALL SMALL SMALL( 1 , ) 1 2   n 0 12 273 S MALL(A2:E2, 1) MALL(A2, E2, 2) S 10 20 50 2 S MALL(A2:E2, 5) MALL(A1:A5, 0) S 5 5 6 S MALL(A1:A5, 6) SQRT SQRT SQRT( )  QRT(16) S 4 3. 5 S QRT(12. 25) 1 2. 25 STDEV STDEV STDEV( , [ 1 , ])  AR V STDEVP STDEVA 274 12 S TDEV(5, 5, 5, 5, 6) TDEV(1, 2, 3, 4, 5) S 5. 2 3 2 4 0. 447 1. 58 2. 24 2 1. 79 S TDEV(1, 1, 1, 1, 6) TDEV(2, 2, 4, 6, 6) S S TDEVP(2, 2, 4, 6, 6) STDEVA STDEVA STDEVA( , [ , ] )  STDEV FALSE 0 TRUE 1 0 STDEV S TDEVA(TRUE, TRUE, TRUE, TRUE, 6) TDEVA("a", 3, 6, 3, "b") S 2. 24 T RUE 1 STDEVP STDEVP STDEVP( , [ ])  1 V ARP 12 275 STDEV STDEVPA TDEVP(5, 5, 5, 5, 6) S 5. 2 3 2 4 0. 4 1. 41 2 1. 79 2 S TDEVP(1, 2, 3, 4, 5) TDEVP(1, 1, 1, 1, 6) S S TDEVP(2, 2, 4, 6, 6) TDEV(2, 2, 4, 6, 6) S STDEVPA STDEVPA STDEVPA( , [ , ])  STDEVP FALSE 0 TRUE 1 0 STDEVA S TDEVPA(TRUE, TRUE, TRUE, TRUE, 6) TDEVPA("a", 3, 6, 3, "b") S 2 T RUE 1 276 12 SUBSTITUTE SUBSTITUTE SUBSTITUTE( , , , [ ])     UBSTITUTE("a b c d e f", "b", "B") S "a B c d e f" "a A b b b c" "a a B B B c" "aaabbccc" S UBSTITUTE("a a b b b c", "a", "A", 2) UBSTITUTE("a a b b b c", "b", "B") S S UBSTITUTE("aaabbccc", "bc", "BC", 2) SUM SUM SUM( , [ 1 , . . . ])  UM(A1:A4) S 4 16 4 100 S UM(A1:D4) UM(A1:A4, 100) S 12 277 SUMIF SUMIF SUMIF( , " ", [ ])    T RUE FALSE 95 S UMIF(A1:A8, "<5") 10 100 27 1 UMIF(A1:A8, "<5", B1:B8) S S UMIF(D1:F3, "=c", D5:F7) UMIF(B1:D1, 1) S SUMIF(B1:D1, SUM(1)) SUMPRODUCT SUMPRODUCT SUMPRODUCT( 2 , , [ , . . . ])  278 12 UMPRODUCT(3, 4) S 12 SUMPRODUCT({1, 2}, {3, 4}) = 3 + 8 = 11 SUMSQ SUMSQ SUMSQ( , [ , . . . ])  UMSQ(3, 4) S 25 4 16 4 5 100 3 4 S UMSQ(A1:A4) UMSQ(A1:D4) S S UMSQ(A1:A4, 10) QRT(SUMSQ(3, 4)) S SYD SYD SYD( , , , )     S YD(10000, 1000, 9, 1) 1 1, 800 10, 000 9 1, 000 12 279 T T T( )  A1 B1 T(B1) (A1) T TAN TAN TAN( )  RADIANS P I TAN T AN(1) 1. 557407725 1 -1 1 45 57. 3 AN(RADIANS(45)) T T AN(3*PI()/4) 280 12 TANH TANH TANH( )  ANH(0) T 0 0. 762 0. 999909 0. 999999996 T ANH(1) ANH(5) T T ANH(10) TIME TIME TIME( 24 , , ) 4 2    9 23 59 5 24 24 IMEVALUE T IME(12, 0, 0) T 2:00 PM 1 T IME(16, 45, 30) IME(0, 900, 0) T 4 :45 PM :00 PM 3 T IME(60, 0, 0) IME(4. 25, 0, 0) T 1 2:00 PM :00 AM 4 12 281 TIMEVALUE TIMEVALUE TIMEVALUE( 24 ) Numbers TIME  IMEVALUE("4/6/88 12:00") T 0. 5 0. 875 2:00 1 21 1 4 24 T IMEVALUE("12:00:59") IMEVALUE("9:00 pm") T 0. 5007 TODAY TODAY 12:00 TODAY()  NOW T ODAY() 1 988 4 6 A pr 6, 1988 282 12 TRIM TRIM 1 TRIM( )  RIM(" s paces s paces s paces " ) T "spaces spaces spaces" TRUE TRUE true TRUE() TRUE TRUE  TRUE() T RUE T RUE() ND(1, TRUE()) A TRUE TRUE A ND(1, TRUE) TRUNC TRUNC TRUNC( , [ ])   0 0 12 283 T RUNC(1. 49, 0) RUNC(1. 50, 0) T 1 1 1. 234 1100 -2 -2 T RUNC(1. 23456, 3) RUNC(1111. 222, -2) T T RUNC(-2. 2, 0) RUNC(-2. 8, 0) T UPPER UPPER UPPER( )  PPER("a b c") U B C A U PPER("First") F IRST VALUE VALUE VALUE( )  umbers N VALUE ALUE("22") V 22 53 V ALUE(RIGHT("The year 1953", 2)) VAR VAR VAR( , [ 1 , ) ]  284 12 VAR 1 VARP AR(5, 5, 5, 5, 6) V 5. 2 3 2 4 0. 2 2. 5 5 4 V AR(1, 2, 3, 4, 5) AR(1, 1, 1, 1, 6) V V AR(2, 2, 4, 6, 6) VARA VARA FALSE VARA( 0 T RUE , [ , ]) 1  VARA 1 VARP VAR ARA(TRUE, TRUE, TRUE, TRUE, 6) V 5 RUE T 1 V ARA("a", 3, 6, 3, "b") 12 285 VARP VARP VARP( , [ 1 , ])  VARP V AR ARP(5, 5, 5, 5, 6) V 5. 2 3 2 4 0. 16 2 4 3. 2 V ARP(1, 2, 3, 4, 5) ARP(1, 1, 1, 1, 6) V V ARP(2, 2, 4, 6, 6) VARPA VARPA FALSE VARPA( 0 TRUE , [ , ) ] 1  VARPA ARA V VARP ARPA(TRUE, TRUE, TRUE, TRUE, 6) V 4 TRUE 1 V ARPA("a", 3, 6, 3, "b") 286 12 VDB VDB v ariable declining balance VDB( , , , , , [ ], [ ])       2  A2:E2 000 10000 1 9 0 1 $2222. 22 1 $1, 728. 40 $339. 20 $297. 60 2 10, 000 9 DB(A2, B2, C2, D2, E2) V 1, 000 DB(A2, B2, C2, 1, 2) V V DB(A2, B2, C2, 8, 9, 2, FALSE) V DB(A2, B2, C2, 8, 9, 2, TRUE) V DB(1000, 100, 4, 0, 1) $500 12 287 VLOOKUP VLOOKUP VLOOKUP( , , , [ ])    1  TRUE 1 FALSE 0 V LOOKUP(20, B2:E6, 2) LOOKUP(21, B2:E6, 2) V E E dolor 5 V LOOKUP("M", C2:E6, 2) LOOKUP("blandit", D2:E6, 2) V V LOOKUP(21, B2:E6, 2, FALSE) 21 288 12 WEEKDAY WEEKDAY WEEKDAY( 3 , [ ])   1 2 3 = 1 = 1 = 7 = 6 = 7 = 0 EEKDAY("Apr 6, 1988", 1) W 4 1 3 2 1 1 0 4 3 2 W EEKDAY("Apr 6, 1988") EEKDAY("Apr 6, 1988", 2) W W EEKDAY("Apr 6, 1988", 3) YEAR YEAR YEAR( )  EAR("April 6, 1988") Y 1988 6 4 2006 Y EAR(NOW()) 2006 12 289 3D 118 1 18 COUPNUM COVAR 223 2 24 A ABS ACCRINTM ACCRINT ACOSH ACOS ADDRESS AND AREAS ASINH ASIN ATAN2 ATANH ATAN AVEDEV AVERAGEA AVERAGE 2 05 206 205 207 206 207 208 208 209 209 210 210 209 2 10 211 2 11 D DATEDIF DATE DAY DB DDB DEGREES DISC DOLLAR 225 224 2 26 226 227 2 27 228 2 28 E EDATE EVEN EXACT EXP 2 29 229 230 2 30 F FACT 230 FALSE 231 FIND 231 FIXED 232 FLOOR 2 32 233 FORECAST FV 2 33 C CEILING 212 CHAR 2 12 CHOOSE 213 CLEAN 213 CODE 214 COLUMNS 215 COLUMN 214 COMBIN 2 15 2 CONCATENATE 16 CONFIDENCE 2 16 CORREL 217 COSH 218 COS 2 17 COUNTA 219 COUNTBLANK 220 COUNTIF 2 20 COUNT 218 COUPDAYBS 221 COUPDAYSNC 222 COUPDAYS 221 G GCD 2 34 H HLOOKUP HOUR HYPERLINK 2 34 235 2 36 I IF 236 INDEX 2 37 INDIRECT 237 INTERCEPT 238 INT 238 290 IPMT IRR ISBLANK ISERROR ISEVEN ISODD ISPMT 239 240 240 41 2 241 241 2 42 L LARGE LCM LEFT LEN LN LOG10 LOG LOOKUP LOWER 258 POWER 58 PPMT 2 60 2 PRICEDISC 260 PRICEMAT PRICE 259 261 PROB PRODUCT 262 262 PROPER 2 62 PV 242 243 244 244 244 45 2 245 245 46 2 Q QuickTime QUOTIENT 63 2 178 R 63 RADIANS 2 64 RANDBETWEEN 2 64 2 RAND 64 RANK 2 RATE 265 266 REPLACE REPT 266 RIGHT 267 ROMAN 267 268 ROUNDDOWN ROUNDUP 269 ROUND 268 270 ROWS 70 ROW 2 M MATCH MAXA MAX MEDIAN MID MINA MINUTE MIN MIRR MODE MOD MONTH MROUND 246 248 247 248 48 2 49 2 250 249 250 251 50 2 2 52 251 S SEARCH 270 71 SECOND 2 271 SIGN 272 SINH 271 SIN 272 SLN SLOPE 273 273 SMALL 74 SQRT 2 STDEVA 275 STDEVPA 276 275 STDEVP 274 STDEV 277 SUBSTITUTE SUMIF 278 78 SUMPRODUCT 2 279 SUMSQ 77 SUM 2 79 SYD 2 N NOT NOW NPER NPV 252 53 2 253 2 54 O ODD OFFSET OR 254 54, 255 2 2 55 P PDF 186 ppleWorks A xcel E 56 PERCENTILE 2 256 PI PMT 257 57 POISSON 2 76 1 76 1 176 T TANH TAN TIMEVALUE 281 280 282 291 TIME TODAY TRIM TRUE TRUNC T 281 82 2 283 83 2 283 80 2 2 84 94, 95 95 84 2 85 2 86 2 286 284 87 2 2 88 89 2 14 1 114 113 113 14 1 115 U UPPER V VALUE VARA VARPA VARP VAR VDB VLOOKUP 151 64 1 64 1 177 71 1 60 1 156 58 1 153 154 58 1 55 1 177 180 182 182 50 1 154 159 150 50 1 51 1 149 51 1 154 50 1 54 1 160 W WEEKDAY Y YEAR 289 41, 48, 107, 115 162 175 75 1 175 75 1 175 175 75 1 75 1 63 1 163 163 172 174 173 25 6 2 6 2 25 199 1 2 191 189 189 188 192 88 1 161 32, 35, 60, 91, 126, 127, 128, 129, 134, 137, 143, 144, 145, 150, 152, 154 96 292 196 201 198 200 202 93 1 195 204 198 177 177 201 17 1 17 1 7 3 9 3 0 3 0 3 26 1 38 1 38 1 64 1 68 1 02 1 05 1 103 110 108 09 1 113 112 8 9 111 104 103 103 107 106 106 106, 113 104 108 07 1 101 12, 155, 156, 157, 158, 1 160, 162, 164 37 38 8 3 37 7 3 183 128 67 198 4, 30 2 36, 40 29 200 9, 90 8 94 7 8 96 88 88 4 9 86 1 9 93 9, 90 8 89, 90 87 8 8 26 3 6 9 5 60 2 6 63 61 177 164 99 1 148 96 1 71 1 293 67 1 166 164 168 67 1 72 1 143 166 164 65 1 173 3 3 31 40 42 3 4 31 6 3 37 1 20 1 41 1 19 1 19 1 49, 55, 81, 125, 130, 131, 132, 133, 136, 137, 141 25 1 23, 129 1 126 132 120 36 1 33 1 136 131 131 33 1 26 1 147 46 1 35 88 1 8 1 48 1 29 1 24 1 129 129 29 1 29 1 164 169 128 202 18, 32 53 1 35 1 134 135 135 Web 152 43 1 144 44 1 24 143 143, 144 146 34 1 141 36 1 20 1 145 130 55 iWork 195 50 76 78 73 73 0 7 294 70 52 69 72 69 65 9 4 49 83 49 48 2 7 71 69 48 51 45 164 170 2 8 1 8 81 2 8 80 80 52 8 6 78 57 8 6 59 6 5 65 65 5 5 74 57 4 5 77 7 5 74 67 67 75 3 5 51 76 28 77 1 77 1 34 Spotlight 36 127 64 1 69 1 1, 145 4 41 35 43 ColorSync 9 3 25 29 1 3 3 33 33 3 3 185 184 83 1 40 41 2 4 42 42 41 35 35 36 4 3 35 70, 191 1 17 1 17 1 117 186 186 86 1 CSV Excel PDF 28 1 204 295 139 137 164 168 137 116 15 1 16 1 34 1 36 1 35 1 135 135 140 138 198 296 [. . . ] ?d e f C LEAN C LEAN(A1) a b c d e f 12 213 CODE CODE CODE( Unicode )  CODE CHAR ODE("A") C A a a A3 1488 f 65 97 C ODE("abc") HAR(97) C C ODE(A3) ODE(" ") C 102 COLUMN COLUMN C OLUMN COLUMN([ ])  C OLUMN(B7) OLUMN() C 2 B 2 214 12 COLUMNS COLUMNS COLUMNS( )  Numbers OLUMNS(B3:D10) C 3 B C D 3 C OLUMNS(5:5) 5 COMBIN COMBIN COMBIN( , )   1, ( 2, 3) (3, 2, 1) OMBIN(3, 2) C 3 OMBIN(3. 2, 2. 3) C 3 3 3 2 C OMBIN(5, 2) COMBIN(5, 3) 10 12 215 CONCATENATE CONCATENATE CONCATENATE( , , [ , . . . ])    & 1 2 3 A1 1 B abc ONCATENATE(B1, ", ", A1) C I psum, Lorem ONCATENATE("a", "b", "c") C "a" & "b" & "c" abc CONFIDENCE CONFIDENCE CONFIDENCE( , , ) 1 = 0. 05  0. 95 95%   ONFIDENCE(0. 05, 1, 10) C 99. 38 100. 62 ONFIDENCE(0. 1, 1, 10) C 99. 48 100. 52 ONFIDENCE(0. 05, 1, 20) C 0. 62 0. 52 0. 44 0. 36 0. 31 100 100 95% 90% C ONFIDENCE(0. 05, 1, 30) ONFIDENCE(0. 05, 1, 40) C 216 12 CORREL CORREL CORREL( 2 , y x )   C ORREL(D2:D7, E2:E7) ORREL(B2:B7, A2:A7) C 1 0. 977265 COS COS COS( )  RADIANS 2 P I 3 4 OS(1) C 0. 540302306 0. 5 /3 0. 5 -1 1 57. 3 C OS(RADIANS(60)) OS(P1()/3) C 60 0 6 C OS(PI()) 180 12 217 COSH COSH COSH( )  OSH(0) C 1 1. 543 74. 21 11, 013. 233 C OSH(1) OSH(5) C C OSH(10) COUNT COUNT COUNT( , [ , ])  1 OUNTA C OUNT(A1:E1) C 5 0 3 0 2 2 C OUNT(A2:E2) OUNT(A3:E3) C C OUNT(A4:E4) OUNT(A5:E5) C C OUNT(1, SUM(4, 5)) 218 12 COUNTA COUNTA COUNTA( , [ , 1 C OUNT ] )  C OUNTA(A1:E1) OUNTA(A2:E2) C 5 5 5 5 2 4 2 C OUNTA(A3:E3) OUNTA(A4:E4) C C OUNTA(A5:E5) OUNTA(1, "a", TRUE, FALSE) C C OUNTA(1, SUM(4, 5)) 12 219 COUNTBLANK COUNTBLANK COUNTBLANK( )  C OUNTBLANK(A1:E1) OUNTBLANK(A2:E2) C 0 1 2 1 5 C OUNTBLANK(A3:E3) OUNTBLANK(A4:E4) C C OUNTBLANK(A5:E5) COUNTIF COUNTIF COUNTIF( , RUE T )   FALSE 95 1 2 3 4 5 6 7 8 A1:A8 OUNTIF(A1:A8, "<4") 3 C C OUNTIF(A1:A8, ">4") OUNTIF(A1:A8, ">=4") C 4 5 220 12 COUPDAYBS COUPDAYBS COUPDAYNC( , , , [ ])    1 2 4 1 2 4 0 1 2 3 4 30E 30  360 30 1 1 360 360 365 360 365 360 30 360 A1:A4 /1/2000 1 /1/2001 9 4 1 62 7 60 3 7 1 7 4 8 31 30 7 1 C OUPDAYBS(A1, A2, A3, A4) 9 1 C OUPDAYBS(A1, A2, A3, 0) OUPDAYBS(DATE(2000, 7, 4), A2, 2, 0) C COUPDAYS COUPDAYS COUPDAYS( , , , [ ])    1 2 1 2 12 221 4 4 30  0 1 2 3 4 30E 360 30 1 1 360 360 365 360 365 360 30 360 A1:A4 /1/2000 1 /1/2001 9 4 0 OUPDAYS(A1, A2, A3, A4) C 90 92 7 7 8 8 9 9 30 360 360 C OUPDAYS(A1, A2, A3, 1) OUPDAYS(A1, A2, A3, 2) C 90 91. 25 90 7 8 7 7 9 8 8 9 9 C OUPDAYS(A1, A2, A3, 3) C OUPDAYS(A1, A2, A3, 4) 365 3 0E/360 COUPDAYSNC COUPDAYSNC COUPDAYNC( , , , [ ])    1 2 4 1 2 4 0 1  30 360 30 360 222 12 2 3 4 30E 360 365 360 30 1 1 360 365 360 A1:A4 /1/2000 1 /1/2001 9 4 1 30 C OUPDAYSNC(A1, A2, A3, A4) 30 9 9 61 9 30 60 1 10 1 C OUPDAYSNC(DATE(2000, 8, 1), A2, A3, A4) 31 10 1 8 C OUPDAYSNC(DATE(2000, 8, 1), A2, A3, 0) 30 10 1 8 8 1 1 COUPNUM COUPNUM COUPNUM( , , , [ ])    1 2 4 1 2 4 0 1 2 3 4 30E 30  360 30 1 1 360 360 365 360 365 360 30 360 12 223 A1:A4 2 4 0 /1/2000 1 /1/2001 4 3 2 1 C OUPNUM(A1, A2, A3, A4) OUPNUM(DATE(2000, 6, 1), A2, A3, A4) C C OUPNUM(DATE(2000, 9, 1), A2, A3, A4) OUPNUM(DATE(2000, 11, 1), A2, A3, A4) C COVAR COVAR COVAR( 2 , 1 2 )   1 2 2 1 C 3:H3 3. 4 3 . 7 4 4. 4 . 4 5. 1 5 2. 1 3 5. 5 6 7. 2 . 3 4. 5 . 4 OVAR(C3:H3, C2:H2) 1. 234 C 2 C 2:H2 DATE DATE DATE( 1 , , )    1 0 10 1910 2010 D ATE(1959, 2, 14) 1959 2 14 224 12 DATEDIF DATEDIF DATEDIF( 2 , ) ,    D M Y MD YM YD A1 4/6/88 A2 6781 222 18 24 6 207 10/30/06 1988 1988 1988 4 4 4 4 6 4 6 6 6 6 2006 2006 2006 30 10 10 30 10 10 10 30 30 30 ATEDIF(A1, A2, "D") D D ATEDIF(A1, A2, "M") ATEDIF(A1, A2, "Y") D D ATEDIF(A1, A2, "MD") ATEDIF(A1, A2, "YM") D D ATEDIF(A1, A2, "YD") ATEDIF(A1, NOW(), "Y") & " years, " & DATEDIF(A1, NOW(), "YM") & " months, and " & D 1 DATEDIF(A1, NOW(), "MD") & " days" 988 4 6 12 225 DAY DAY DAY( ) Numbers  AY("4/6/88 11:59:22 AM") D 6 DB DB DB( , , , , [ ])      12 A2:E2 1000 1 4 1 12 00 $438 $246. 16 $138. 34 $77. 75 $328. 50 $219 $109. 50 D B(A2, B2, C2, D2, E2) B(A2, B2, C2, 2, E2) D D B(A2, B2, C2, 3, E2) B(A2, B2, C2, 4, E2) D D B(A2, B2, C2, D2, 9) B(A2, B2, C2, D2, 6) D D B(A2, B2, C2, D2, 3) 226 12 DDB DDB DDB( , , , , [ ])      2 DB(1000, 100, 4, 1) D $500 $250 $125 $25 $250 $750 $150 $0 D DB(1000, 100, 4, 2) DB(1000, 100, 4, 3) D D DB(1000, 100, 4, 4) DB(1000, 100, 4, 1, 1) D D DB(1000, 100, 4, 1, 3) DB(1000, 100, 4, 2, 3) D D DB(1000, 100, 4, 3, 3) DEGREES DEGREES DEGREES( )  EGREES(PI()) D 180 57. 2957795130823 = 180 1 D EGREES(1) 12 227 DISC DISC DISC( , , , , [ ])      0 1 2 3 4 30E 100 100 30 360 30 1 1 360 360 365 360 365 360 30 360 A1:E1 /1/2001 1/1/2000 1 90 100 0 10% 20% 18% ISC(A1, B1, C1, D1, E1) D D ISC(A1, B1, 80, D1, E1) ISC(A1, B1, C1, 110, E1) D DOLLAR DOLLAR DOLLAR( , [ ])   2 DOLLAR 1 5 228 12 D OLLAR(2323. 124) OLLAR(2323. 125) D $2, 323. 12 $2, 323. 13 $100 ($12. 000) $120 $12. 000 D OLLAR(99. 554, 0) OLLAR(12, 3) D D OLLAR(-12, 3) OLLAR(123, -1) D EDATE EDATE EDATE( , )   DATE("1/15/2000", 1) E 2/15/2000 1/15/1998 1 24 E DATE("1/15/2000", -24) EVEN EVEN EVEN( 0 )  DD O VEN(1) E 2 2 4 -4 0 E VEN(2) VEN(2. 5) E E VEN(-2. 5) VEN(0) E 12 229 EXACT EXACT EXACT( , ) TRUE   XACT("toledo", "toledo") E TRUE FALSE TRUE E XACT("Toledo", "toledo") XACT(toledo", "tol" & "edo") E EXP EXP EXP( e )  E XP(1) XP(LN(5)) E 2. 71828182845905 5 XP E LN e FACT FACT FACT( )  ACT(5) F 120 1 24 F ACT(0) ACT(4. 5) F 1 2 3 4 ! [. . . ]