Apple iWork '09 Manual do Utilizador Página 189
- Página / 372
- Índice
- MARCADORES
Avaliado. / 5. Com base em avaliações de clientes
Chapter 8 Numeric Functions 189
RAND
The RAND function returns a random number that is greater than or equal to 0 and
less than 1.
RAND()
Usage Notes
The RAND function does not have any arguments. However, you must include the Â
parentheses: =RAND().
Any time you change a value in the table, a new random number greater than or Â
equal to 0 and less than 1 is generated.
Example
=RAND() returns, for example, 0.217538648284972, 0.6137690856, 0.0296026556752622, and
0.4684193600 for four recalculations.
Related Topics
For related functions and additional information, see:
“RANDBETWEEN” on page 189
“Listing of Numeric Functions” on page 167
“Value Types” on page 36
“The Elements of Formulas” on page 15
“Using the Keyboard and Mouse to Create and Edit Formulas” on page 26
“Pasting from Examples in Help” on page 41
RANDBETWEEN
The RANDBETWEEN function returns a random integer within the specied range.
RANDBETWEEN(lower, upper)
 lower: The lower limit or bound. lower is a number value.
 upper: The upper limit or bound. upper is a number value.
Usage Notes
Any time you change a value in the table, a new random number between the Â
lower and upper limits is generated.
Example
=RANDBETWEEN(1, 10) returns, for example, 8, 6, 2, 3, and 5 for ve recalculations.
- 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
Manuais e produtos relacionados com Software Apple iWork '09
Software Apple Macintosh System 7.5 Manual do Utilizador
(114 páginas)
(114 páginas)
Software Apple Keynote '08 Manual do Utilizador
(230 páginas)
(230 páginas)
Software Apple DVD Studio Pro 4 Manual do Utilizador
(777 páginas)
(777 páginas)
Software Apple LiveType 2 Manual do Utilizador
(157 páginas)
(157 páginas)
Software Apple Pages '09 Manual do Utilizador
(324 páginas)
(324 páginas)
Software Apple Mac OS X 10.2 Manual do Utilizador
(21 páginas)
(21 páginas)
Software Apple iDVD '08 Manual do Utilizador
(36 páginas)
(36 páginas)
(14 páginas)
(15 páginas)
Software Apple Logic Express 7 Manual do Utilizador
(522 páginas)
(522 páginas)
Software Apple Motion 2 Tutorials Manual do Utilizador
(235 páginas)
(235 páginas)
© 2020, manymanuals-pt.com. Todos os direitos reservados. | 0.067 s |
Manymanuals.com
Manymanuals.de
Manymanuals.fr
Manymanuals.it
Manymanuals.pl
Manymanuals.cz
Manymanuals.es
Manymanuals-pt.com
Comentários a estes Manuais