:Math and Trigonometric Functions RANDBETWEEN Function-Table skills免费ppt模版下载-道格办公

Math and Trigonometric Functions RANDBETWEEN Function

Picture and text skills
Case

Returns a random integer greater than or equal to the specified minimum value and less than the specified maximum value. A new value will be returned each time the worksheet is calculated.

Syntax
RANDBETWEEN（bottom,top）
Bottom The smallest integer that the RANDBETWEEN function will return.
Top The largest integer that the function RANDBETWEEN will return.

How to use the RANDBETWEEN function to generate random integer values in real time ?
As shown in the title, we want to generate random integer values greater than 50 and less than 100 in real time.

￭Open the form, place the cursor at (D2), and click Insert Function-Mathematics and Trigonometric Functions-RANDBETWEEN function.
A dialog box pops up with two parameters:
"Minimum integer" and "Maximum integer" respectively fill in the integer value.

￭Enter 50 in "Minimum Integer" and 100 in "Maximum Integer", which means to generate random integer values greater than 50 and less than 100 in real time.
Click OK to get a random integer value greater than 50 and less than 100.
Place the cursor in the lower right corner of (D2), pull down and right when it is + to fill in the formula, and all integers can be generated in real time.

Articles are uploaded by users and are for non-commercial browsing only. Posted by: Lomu, please indicate the source: https://www.daogebangong.com/en/articles/detail/shu-xue-he-san-jiao-han-shu-RANDBETWEEN-han-shu.html