| Line 1: |
Line 1: |
| | <div style="font-size:30px">'''RANDOM(MaxNumber)'''</div><br/> | | <div style="font-size:30px">'''RANDOM(MaxNumber)'''</div><br/> |
| − | **RANDOM(),returns a random number with a value less than MaxNumber specified. | + | **RANDOM(),returns a random number with a value less than ''MaxNumber'' specified. |
| | | | |
| | ==Description== | | ==Description== |
| Line 6: |
Line 6: |
| | *The random numbers generate a sequence of numbers randomly. | | *The random numbers generate a sequence of numbers randomly. |
| | *The generated random numbers are changing each time of the calculation. | | *The generated random numbers are changing each time of the calculation. |
| | + | *If ''MaxNumber'' is not specified, random number between 0 and 1 is displayed. |
| | + | |
| | | | |
| | ==Examples== | | ==Examples== |
| − | #=RANDOM(3) = 1.55062430785339
| + | 1) RANDOM(3) = 1.55062430785339 |
| − | #=RANDOM(|2|,4) = 46.92529523745179
| + | |
| − | #=RANDOM()+25 = 25.684887402923778
| + | 2) RANDOM(|2|) = |
| | + | <div id="2SpaceContent" class="zcontent" align="left"> |
| | + | |
| | + | {| id="TABLE3" class="SpreadSheet blue" |
| | + | |- class="even" |
| | + | | class="sshl_f" |'''MaxNumber''' |
| | + | | class=" " | |
| | + | | class=" " |'''RANDOM''' |
| | + | | class=" " | |
| | + | |
| | + | |- class="odd" |
| | + | | class="sshl_f" |1 0 |
| | + | | class=" " | |
| | + | | class=" " |0.9354179973956638 |
| | + | | class=" " |-0.047590545167235376 |
| | + | |
| | + | |- class="even" |
| | + | | class="sshl_f" |0 1 |
| | + | | class=" " | |
| | + | | class=" " |-0.3112243800619441 |
| | + | | class=" " |0.7250106307199662 |
| | + | |
| | + | |} |
| | + | |
| | + | |
| | + | 3) RANDOM(5)+25 = 29.49502665283281 |
| | | | |
| | ==Related Videos== | | ==Related Videos== |
| Line 17: |
Line 44: |
| | | | |
| | ==See Also== | | ==See Also== |
| − | *[[Manuals/calci/RANDOM | RANDOM ]] | + | *[[Manuals/calci/RAND | RAND ]] |
| | *[[Manuals/calci/RANDBETWEEN | RANDBETWEEN ]] | | *[[Manuals/calci/RANDBETWEEN | RANDBETWEEN ]] |
| | | | |