How to generate random numbers in excel
- 王林Original
- 2020-06-10 10:21:0724874browse
To generate random numbers, you can use the RAND() function.
1. Enter the formula in the cell where you need to generate a random number: =RAND( )
2. Press Enter to generate a random number between 0 and 1
If we need random numbers in other ranges, we can use the RAND() function as the base number.
3. For example, if we need to generate a random number between 30 and 60, we need to enter the formula =30 RAND( )*(60-30)## in the cell.
#4. Press the Enter key to generate a random number between 30 and 60
The above is the detailed content of How to generate random numbers in excel. For more information, please follow other related articles on the PHP Chinese website!
Statement：
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article：How to insert check mark in excelNext article：How to insert check mark in excel