Apple iWork '09 Manual de usuario Pagina 12
- Pagina / 372
- Tabla de contenidos
- MARCADORES
- Formulas and 1
- Functions User Guide 1
- Contents 3
- 4 Contents 4
- Contents 5 5
- Chapter 8: Numeric Functions 6
- Contents 7 7
- 8 Contents 8
- Contents 9 9
- Chapter 11: Text Functions 10
- Contents 11 11
- Functions 13
- Using Formulas in Tables 15
- Creating Your Own Formulas 19
- Adding Functions to Formulas 21
- Removing Formulas 24
- Using Operators in Formulas 28
- The Comparison Operators 29
- An Introduction to Functions 33
- Information About Functions 34
- Value Types 36
- Pasting from Examples in Help 41
- Date and Time Functions 42
- DATEVALUE 47
- MONTHNAME 54
- NETWORKDAYS 54
- TIMEVALUE 57
- YEARFRAC 63
- Duration Functions 64
- DUR2DAYS 65
- DUR2HOURS 65
- DUR2MILLISECONDS 66
- DUR2MINUTES 67
- DUR2SECONDS 68
- DUR2WEEKS 69
- DURATION 70
- STRIPDURATION 71
- Engineering Functions 72
- BASETONUM 73
- =BIN2DEC(”1001”) returns 9 76
- =BIN2DEC(101101) returns 45 76
- =BIN2HEX(101101) returns 2D 77
- =BIN2OCT(”10011”) returns 23 78
- Supported Conversion Units 80
- Pressure 81
- Magnetism 82
- Temperature 82
- Metricprexes 83
- =DEC2OCT(100) returns 144 85
- =HEX2DEC(”F”, 3) returns 015 90
- =HEX2DEC(“3F”) returns 63 90
- =HEX2OCT(”F”, 3) returns 017 91
- =HEX2OCT(“4E”) returns 116 91
- NUMTOBASE 92
- =OCT2BIN(15) returns 01101 93
- =OCT2DEC(127,4) returns 0087 94
- =OCT2DEC(15) returns 13 94
- =OCT2HEX(127,4) returns 0057 95
- =OCT2HEX(15) returns 0D 95
- Financial Functions 96
- ACCRINTM 101
- BONDDURATION 103
- BONDMDURATION 104
- COUPDAYBS 105
- COUPDAYS 107
- COUPDAYSNC 108
- CUMPRINC 112
- =NPER(B2, C2, D2 132
- =0.07/12 -1500 170000 0 1 132
- PRICEDISC 138
- PRICEMAT 140
- RECEIVED 146
- YIELDDISC 152
- YIELDMAT 153
- Examples 157
- =ISEVEN(2) returns TRUE 162
- =ISEVEN(2.75) returns TRUE 162
- =ISEVEN(3) returns FALSE 162
- =ISODD(3) returns TRUE 163
- =ISODD(3.75) returns TRUE 163
- =ISODD(2) returns FALSE 163
- Numeric Functions 167
- FACTDOUBLE 175
- =GCD(8, 10) returns 2 177
- =GCD(99, 102, 105) returns 3 177
- =GCD(34, 51) returns 17 177
- MULTINOMIAL 184
- QUOTIENT 188
- RANDBETWEEN 189
- ROUNDDOWN 192
- SUMPRODUCT 200
- SUMX2MY2 202
- SUMX2PY2 203
- Reference Functions 206
- HYPERLINK 213
- Â row-index can’t be 215
- INDIRECT 216
- TRANSPOSE 222
- Statistical Functions 225
- AVERAGEA 232
- AVERAGEIF 233
- AVERAGEIFS 234
- BETADIST 236
- BINOMDIST 238
- CONFIDENCE 242
- COUNTBLANK 246
- COUNTIFS 248
- CRITBINOM 252
- EXPONDIST 253
- FORECAST 256
- FREQUENCY 257
- GAMMADIST 259
- GAMMAINV 260
- INTERCEPT 262
- Additional Statistics 267
- LOGNORMDIST 269
- =MAXA(1, 2, 3, 4) returns 4 271
- =MINA(1, 2, 3, 4) returns 1 273
- NEGBINOMDIST 275
- NORMDIST 276
- NORMSDIST 277
- NORMSINV 278
- PERCENTILE 279
- PERCENTRANK 280
- =PERMUT(10, 3) returns 720 281
- =PERMUT(5, 2) returns 20 281
- QUARTILE 284
- STANDARDIZE 289
- Text Functions 306
- =CODE(”b”) returns 98 308
- CONCATENATE 310
- “n” in “on”) 313
- =LEN(”12345”) returns 5 315
- SUBSTITUTE 322
- Trigonometric Functions 326
- =ACOSH(COSH(5)) returns 5 328
- =ATANH(TANH(2)) returns 2 332
- =TAN(3*PI()/4) returns -1 338
- Questions? 351
- More on Rounding 355
- Trapping Division by Zero 360
- Survey Results Example 362
- 366 Index 366
- Index 367 367
- 368 Index 368
- Index 369 369
- 370 Index 370
- Index 371 371
- 372 Index 372
Relacionado con productos y manuales para Software Apple iWork '09
(114 paginas)
(230 paginas)
(777 paginas)
(157 paginas)
(324 paginas)
(21 paginas)
(36 paginas)
(14 paginas)
(15 paginas) (522 paginas)
(235 paginas)
© 2020, manymanuals.es. Todos los derechos reservados | 0.176 s |
Manymanuals.com
Manymanuals.de
Manymanuals.fr
Manymanuals.it
Manymanuals.pl
Manymanuals.cz
Manymanuals.es
Manymanuals-pt.com
Comentarios a estos manuales