ユーザーズガイド APPLE NUMBERS 2008

[. . . ] [. . . ] 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 + - (, ) / $ % . 4 Option Shift 5 6 4 S hift Option Shift Option Option é O ption E U. S. U 5 7 127 Mac OS X 1 2 3 1 4 5 Numbers m Numbers 128 7 Zapfino Hoefler   1   1 2 Mac OS X 1 2 3 7 129 m 130 7 1 2 3 5 5 4 [ ] 1 1 36 1 2 3 3 7 131 1 2 3 4 1 1 2 1 2 2 2 2 132 7 1 2 3 5 pt 12 14 14 1 36 1 2 3 7 133 m m 161 Tab O ption Tab 137 m m Numbers 134 7 1 2 3 Control 1 2 3 Control 1 2 7 135 1 2 1 3 Option 4 1 1 1 1 1 2 136 7 3 Return Numbers Numbers Numbers m eturn R m m eturn R * 1 - Option 8 • 1 eturn R 1 m eturn R 2 7 137 1 37 1 2 3 Numbers 4 5 6    1 Shift  Tab Return Shift Return Tab 1 Return 138 7 1 37 1 2 3 4    1 Shift Return Shift Tab Return 1 Tab Return    7 139   1 1. 1 1 . 1. 1 I A a) ( 1 1) ( a) i ) ( 1) ( a) 1 2 3 4 5    1 Shift Return Shift Tab Return 1 Tab  Return   140 7 1 2 3 Return 4 5 O ption 1 43 1 7 141 1 4 1 2 3 4 5 1 164 2 64 1 3 Return 142 7 4 1 59 136 1 54 160 HTML Web N umbers URL Web Web Web Web Web Web 1 www h ttp Numbers Web 2 3 W eb 7 143 4 URL Web URL 1 Numbers Web 2 3 4 5 m 144 7 m 41 m Control m 2/10 Control / m Control Numbers teh the 1 2 Numbers 7 145 1st 2nd 3rd URL Web Mail S afari N umbers Web (c) Numbers © Numbers m Option Numbers m m 146 7 ; m 1 2 3 4 5 6 7 Control 3 6 7 147 m m 148 7 8 8 PDF m m m m m 1 hift S A 149 m m Option m Numbers Numbers m D elete - m m m 10 m 45 Shift 1 Shift Numbers 150 8 m 1 52 m 1 2 3 1 2 4 1 2 8 151 1 2 1 2 3 4 Numbers Numbers 152 8 1 2 3 1 2 3 X Y  X  Y X Y X Y X/Y 2 X/Y 8 153 m Option Shift N umbers m m m m m 45 Shift 154 8 m 1 1 2 3 4 5 6 7 7 5 8 155 m m m 156 8 1 2 3 4 5 6 7 8 8 157 1 2 3 100 m m 158 8 100 100 50 100 50 100 100 100 1 1 2 Shift 8 159 1 2 Shift 2 1 2 3 4 160 8 2 2 100 8 161 1 2 3 4 5 6 1 2 3 Finder 162 8 4 5 8 163 Numbers m m Option O ption S hift 1 2 3 2 2 2 164 8 4 3 1 5 E sc E scape D elete Delete 1 1 m 2 m 1 1 8 165 165 m Option m S hift m Delete Delete S hift 1 2 166 8 3 4 2 Option 2 1 2 3 2 4 1 m m m 1 m 1 8 167 m 3 m m m 168 8 m m m 8 169 Numbers m Finder m 170 8 m m m 1 91 D elete Numbers QuickTime        TIFF GIF JPEG PDF PSD EPS PICT Numbers Finder m m Finder m m 1 70 8 171 1 2 1 71 3 4 Shift 5 6 R eturn 7 172 8 1 Shift 2 3 4 5 6 7 Return - m 1 2 8 173 3 4 3 5 eturn R - Numbers 1 174 8 2 3 8 175 4 PDF PDF Numbers P DF PDF E xcel Excel A ppleWorks A ppleWorks N umbers PDF 1 2 3 4 Excel Numbers Excel PDF P DF Excel Excel PDF AppleWorks A ppleWorks PDF PDF Lasso PDF PDF 176 8 Numbers Flash Numbers Q uickTime i Tunes       MOV FLASH MP3 MPEG-4 AIFF AAC m Finder m m 1 70 m Finder m iTunes iPhoto 8 177 m m 1 70 QuickTime 1 2 3 4 QuickTime 5 QuickTime 6 178 8 9 9 vCard Numbers umbers N vCard vCard 179 Numbers URL URL URL URL URL AIM AIM IM IM IM IM IM I M IM IM 180 9 AIM IM IM IM IM IM IM IM AIM IM IM Yahoo Yahoo Yahoo Yahoo 9 181 180 vCard 1 2 vCard 3 1 1 vCard vCard 1 7 7 vCard m m 1 1 80 1 vCard vCard 182 9 10 Numbers 10 Numbers xcel E i Web 1 2 3 4 39 5 183 1 2 1 2 6 185 7 C olorSync 1 2 3 1 1 1 184 10 umbers N 4 5 ColorSync Quartz ColorSync 1 2 C olorSync 3 Numbers 4 Quartz Quartz Quartz 10 umbers N 185 ColorSync Quartz ColorSync ColorSync ColorSync C olorSync Excel PDF C SV Numbers 1 2 PDF S afari PDF PDF PDF Mac OS X Windows E xcel Microsoft Excel Excel CSV CSV CSV 3 4 5 6 186 10 umbers N iWeb iWeb W eb Web iWeb iWeb N umbers Podcast iWeb PDF 1 iWeb ‘08 N umbers PDF 2 Numbers iWeb 3 iWeb Podcast 1 Web iTunes Podcast Podcast PDF Podcast iWeb i Web iWeb 10 umbers N 187 11 Numbers 11 Numbers Numbers umbers N       1 Numbers 1 79 188 1 Numbers 49     1 2 1 06 113 3 4 5 11 umbers N 1 2 189 1 2 1 20 3 160 4 154 5 1 171 2 155 156 1 56 158 158 3 4 190 11 umbers N      1 171 177 1 77 1 50 2 3 4 154 Delete 11 umbers N 191 m Numbers 38 m 38 1 2 3 /Application Support/iWork/Numbers/Templates/My Templates/ /Application Support/iWork/ Numbers/Templates/ 4 F inder 192 11 umbers N 12 12 3 8 96 Numbers 68 1 SUM A 2 10 =SUM(A2:A10) 1 TRUE FALSE     CONCATENATE( cat , s OR(4<1, 5<6) LOOKUP(5, C2:C6, D2:D6) EEKDAY(TODAY() W 193 [ ] 2 arg2 3 F UNCTION(arg1, , arg3) . . . T RUE FALSE N umbers umbers N RUE T FALSE 194 12 Numbers DATE (224 DATEDIF (225 DAY (226 EDATE (229 HOUR (235 MINUTE (250 MONTH (251 NOW (253 SECOND (271 TIME (281 TODAY (282 WEEKDAY (289 YEAR (289 ) ) ) ) ) ) ) ) ) ) ) ) ) ) 24 24 0 23 1 2 TIMEVALUE (282 12 195 Numbers ACCRINT (205 ACCRINTM (206 COUPDAYBS (221 COUPDAYS (221 COUPDAYSNC (222 COUPNUM (223 DB (226 DDB (227 DISC (228 FV (233 IPMT (239 IRR (240 ISPMT (242 MIRR (250 NPER (253 ) ) ) ) ) ) ) ) ) ) ) ) ) ) ) 196 12 NPV (254 PMT (257 PPMT (258 PRICE (259 ) ) ) ) ) ) ) ) ) ) PRICEDISC (260 PRICEMAT (260 PV (262 RATE (265 SLN (272 SYD (279 VDB (287 ) 12 197 TRUE F ALSE Numbers AND (208 FALSE (231 IF (236 NOT (252 OR (255 TRUE (283 ) ) ) ) TRUE ) TRUE FALSE FALSE FALSE 2 TRUE 1 1 ) TRUE Numbers ISBLANK (240 ISERROR (241 ISEVEN (241 ISODD (241 ) ) ) ) TRUE TRUE TRUE TRUE FALSE FALSE FALSE FALSE 198 12 Numbers ADDRESS (207 AREAS (208 CHOOSE (213 COLUMN (214 COLUMNS (215 HLOOKUP (234 HYPERLINK (236 INDEX (237 INDIRECT (237 LOOKUP (245 MATCH (246 OFFSET (255 ROW (270 ROWS (270 VLOOKUP (288 ) ) ) ) ) ) COLUMN ) ) ) 1 Web ) ) ) ) 1 2 1 OW R ) ) 12 199 Numbers ABS (205 CEILING (212 COMBIN (215 EVEN (229 EXP (230 FACT (230 FLOOR (232 GCD (234 INT (238 LCM (243 LN (244 LOG (245 LOG10 (245 MOD (250 MROUND (252 ODD (254 PI (256 POWER (258 PRODUCT (262 ) ) ) ) ) ) ) ) ) ) ) ) ) ) ) ) ) ) ) ) ) ) ) ) ) ) ) 0 15 0 0 0 e 10 1 0 0 ^ 2 0 QUOTIENT (263 RAND (264 ROMAN (267 ROUND (268 ROUNDUP (269 SIGN (271 RANDBETWEEN (264 ROUNDDOWN (268 0 1 -1 200 12 SQRT (274 SUM (277 SUMIF (278 SUMSQ (279 TRUNC (283 ) ) ) ) SUMPRODUCT (278 ) ) 2 Numbers ACOS (206 ACOSH (207 ASIN (209 ASINH (209 ATAN (209 ATAN2 (210 ATANH (210 COS (217 COSH (218 DEGREES (227 RADIANS (263 SIN (271 SINH (272 TAN (280 TANH (281 ) ) ) ) ) ) ) ) ) ) ) ) ) ) ) x 0 / 2 /2 / 2 /2 12 201 Numbers AVEDEV (210 AVERAGE (211 AVERAGEA (211 CONFIDENCE (216 ) ) ) ) CORREL (217 COUNT (218 COUNTA (219 ) ) ) ) ) ) ) y 2 COUNTBLANK (220 COUNTIF (220 COVAR (224 FORECAST (233 INTERCEPT (238 LARGE (242 MAX (247 MAXA (248 MEDIAN (248 MIN (249 MINA (249 MODE (251 ) ) ) ) ) ) ) 2 x y n ) 202 12 PERCENTILE (256 POISSON (257 PROB (261 RANK (264 SLOPE (273 SMALL (273 STDEV (274 STDEVA (275 STDEVP (275 STDEVPA (276 VAR (284 VARA (285 VARP (286 VARPA (286 ) ) ) ) ) ) ) ) ) ) ) ) n ) ) 12 203 Numbers CHAR (212 CLEAN (213 CODE (214 DOLLAR (228 EXACT (230 FIND (231 FIXED (232 LEFT (244 LEN (244 LOWER (246 MID (248 PROPER (262 REPLACE (266 REPT (266 RIGHT (267 SEARCH (270 ) ) ) ) Unicode U nicode Unicode ) ) ) 0 TRUE 31 ) CONCATENATE (216 ) ) ) ) ) ) ) ) ) 2 1 2 SUBSTITUTE (277 T (280 TRIM (283 UPPER (284 VALUE (284 ) ) ) 1 ) ) 204 12 ABS ABS ABS( 0 )  A1 5 3 3 0 BS(A1) A 5 A BS(8-5) BS(5-8) A A BS(0) A1 BS(A1) A 0 ACCRINT ACCRINT ACCRINT( , , , , , , [ ])       1 2 4 0 1 1 2 4  0 1 2 30 360 30 1 360 360 360 12 205 3 4 30E 365 360 30 1 365 360 A1:A7 1/1/2000 3 /1/2000 7 /1/2000 0 . 10 1 000 2 0 50 CCRINT(A1, A2, A3, A4, A5, A6, A7) A ACCRINTM ACCRINTM ACCRINTM( , , , , [ ])      0 1 2 3 4 30E 30 0 1 360 30 1 1 360 360 365 360 365 360 30 360 1000 0 1/1/2000 1 0/1/2000 0 . 10 CCRINTM(A1, A2, A3, A4, A5) 75 A A1:A5 ACOS ACOS A COS 0 ACOS( C OS ) -1  1 206 12 DEGREES COS(SQRT(2)/2) A EGREES(ACOS(. 5)) D 0. 785398163397448 1 0 6 0. 5 60 4 A COS(0. 54030230586814) ACOSH ACOSH ACOSH( ) 1  A COSH(10. 0676619957778) COSH(COSH(5)) A 5 3 ADDRESS ADDRESS ADDRESS( , , [ ], [ ], [ ])    1 2 3 4 TRUE 1 A1   12 207 A DDRESS(3, 5) DDRESS(3, 5, 2) A $ E$3 E$3 A DDRESS(3, 5, 3) DDRESS(3, 5, 4) A $E3 E3 AND AND AND( TRUE , [ , . . . ]) FALSE  ND(TRUE, TRUE) A 0 FALSE TRUE RUE T 2 0 A5 FALSE 50 100 A ND(1, 0, 1, 1) ND(A5>50, A5<100) A F ALSE TRUE AREAS AREAS AREAS( ) 1  REAS(A1:F8) A 1 1 2 3 A REAS(C2:C8 B6:E6) REAS((A1:F8, A10:F18)) A A REAS((A1:C1, A3:C3, A5:C5)) 208 12 ASIN ASIN ASIN /2 ASIN( /2 90 SIN 90 ) -1  1 DEGREES SIN(0. 8411470984807897) A EGREES(ASIN(. 5)) D 30 1 0 3 1 SIN 0. 5 57. 3 SIN 0. 841470985 ASINH ASINH ASINH( )  A SINH(27. 2899171971277) SINH(SINH(1)) A 1 4 ATAN ATAN - / 2 ATAN( /2 90 90 )  DEGREES TAN(1) A 0. 785398163 45 45 1 D EGREES(ATAN(1)) 12 209 ATAN2 ATAN2 ATAN( , ) x   x y DEGREES TAN2(1, 1) A 0. 78539816 45 45 (1, 1) D EGREES(ATAN2(5, 5)) ATANH ATANH ATANH( ) 1 1  TANH(0. 995054753686731) A 3 A TANH(TANH(2)) 2 AVEDEV AVEDEV AVEDEV( , [ , ])  A VEDEV(2, 2, 2, 4, 4, 4) 1 0. 6666667 VEDEV(2, 2, 2, 2, 3, 3, 3, 3, 4, 4, 4, 4) A 210 12 AVERAGE AVERAGE AVERAGE( , [ , ] )  T RUE FALSE VERAGE(4, 4, 4, 6, 6, 6) A 5 3 A VERAGE(2, 2, 2, 2, 3, 3, 3, 3, 4, 4, 4, 4) AVERAGEA AVERAGEA AVERAGEA( , [ , ) ]  AVERAGE FALSE 0 0 TRUE 1 AVERAGE VERAGEA(A1:A4) A 0 A1 A4 10 10 A4 A4 4 a 6 b 4 2. 5 2 5 5 a T RUE 1 0 16 4 . 5 2 AVERAGE(A1:A4) A VERAGEA(A1:A4) 0 T RUE A1 1 4 4 0. 25 . 25 0 A VERAGEA(A1:A4) A1 ALSE 0 T RUE 1 F FALSE F FALSE ALSE TRUE 1 4 12 211 CEILING CEILING CEILING( 0 , )   0 FLOOR ROUNDUP R INT R OUND OUNDDOWN TRUNC EILING(0. 25, 1) C 1 2 -2 6 80 7. 5 C EILING(1. 25, 1) EILING(-1. 25, -1) C C EILING(5, 2) EILING(73, 10) C C EILING(7, 2. 5) CHAR CHAR CHAR( nicode U ) 1 65535  ODE C 212 12 C HAR(98. 6) ODE("b") C b 98 98 CHOOSE CHOOSE CHOOSE( , , [ , ])   1 A1:A7 Monday Tuesday Wednesday Thursday Friday Saturday Sunday Thursday 3 HOOSE(4, A1, A2, A3, A4, A5, A6, A7) C C HOOSE(3, "1st", "second", 7, "last") 7 CLEAN CLEAN nicode U 0 31 CLEAN( )  29 127 1 141 143 144 157 SUBSTITUTE 0 31 CLEAN TRIM b c d e f a A1 a b c ??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 ! [. . . ] [. . . ]