Difference between revisions of "Manuals/calci/RAND"
Jump to navigation
Jump to search
(8 intermediate revisions by 4 users not shown) | |||
Line 1: | Line 1: | ||
<div style="font-size:30px">'''RAND()'''</div><br/> | <div style="font-size:30px">'''RAND()'''</div><br/> | ||
− | + | **RAND(),returns a random number between 0 and 1. | |
==Description== | ==Description== | ||
− | *This function gives the real numbers ,circulated in a uniformed way. | + | *This function gives the real numbers, circulated in a uniformed way. |
*The random numbers generate a sequence of numbers which is lying between 0 and 1. | *The random numbers generate a sequence of numbers which is lying between 0 and 1. | ||
*The generated random numbers are changing each time of the calculation. | *The generated random numbers are changing each time of the calculation. | ||
− | *To | + | *To find the random real number between <math>a</math> and <math>b</math>, we can use RAND()*(b-a)+a. |
− | *Suppose we want to keep the same rand numbers for | + | *Suppose we want to keep the same rand numbers for calculation, we can enter =RAND() in the formula bar. |
+ | ==Examples== | ||
+ | #=RAND() = 0.37205533031374216 | ||
+ | #=RAND()*100 = 46.92529523745179 | ||
+ | #=RAND()+25 = 25.684887402923778 | ||
− | == | + | ==Related Videos== |
− | |||
− | |||
− | |||
+ | {{#ev:youtube|PiyApfbQ41c|280|center|RAND}} | ||
==See Also== | ==See Also== | ||
− | *[[Manuals/calci/RANDBETWEEN | RANDBETWEEN ]] | + | *[[Manuals/calci/RANDBETWEEN | RANDBETWEEN ]] |
+ | ==References== | ||
+ | *[http://www.techonthenet.com/excel/formulas/rand.php Rand Function] | ||
− | + | ||
+ | |||
+ | |||
+ | *[[Z_API_Functions | List of Main Z Functions]] | ||
+ | |||
+ | *[[ Z3 | Z3 home ]] |
Latest revision as of 14:52, 28 June 2018
RAND()
- RAND(),returns a random number between 0 and 1.
Description
- This function gives the real numbers, circulated in a uniformed way.
- The random numbers generate a sequence of numbers which is lying between 0 and 1.
- The generated random numbers are changing each time of the calculation.
- To find the random real number between and , we can use RAND()*(b-a)+a.
- Suppose we want to keep the same rand numbers for calculation, we can enter =RAND() in the formula bar.
Examples
- =RAND() = 0.37205533031374216
- =RAND()*100 = 46.92529523745179
- =RAND()+25 = 25.684887402923778
Related Videos
See Also
References