China Naming Network - Ziwei knowledge - 22. Random function: rank function

22. Random function: rank function

Basic usage

= Rank ()

=RANK () random 0- 1

=RANK () random 0- 100

= round (rank () 100,0) is rounded randomly from 0 to100.

=RANK() (120-60) 60 Random 60- 120

=RANDBETWEEN (minimum, maximum)

=RANDBETWEEN( 1, 100) random integer 1- 100.

=RANDBETWEEN(- 1,1) random-1-1integer

note:

1. For the RANK function, there are no parameters, and it returns any decimal between 0 and 1.

2. For RANDBETWEEN, any integer between bottom (minimum value) and top (maximum value) is returned, so top cannot be less than bottom.

3.randhe randbetween generates random values, which will change with the change of cells or the opening of Excel by default (automatic calculation is turned on).

4. news F9 refresh

Audit random inspection

Add an auxiliary column and enter =RANK () to sort.

Randomly generate six-digit verification code

Randomly generate a six-digit verification code

=TEXT(INT(RAND() 999999)," 000000 ")

INT function: rounding

Text function

Randomly generate six-digit verification code

1. Randomly generate a 1 bit function consisting of numbers and letters (including case).

= MID(" 0 123456789 abcdefghijklmnopqrstuvwxyzabcdefghijklmnopqrstuvwxyz,INT(RANK()*62)+ 1, 1)

Use "&"for 2.6-bit random numbers. Work together.

Machine-selected two-color ball

1. Set the red ball details.

Enter =RAND () in cells A2:A36.

Enter =RANK(A2, 2: 36) in cells B2:B36 to sort.

The six numbers of the red ball are randomly equal to the median of B2: B36. Be careful not to repeat them.

2. Set the number of blue balls

=RANDBETWEEN( 1, 16)

Machine selection lottery

1. Set the red ball details.

Just like setting the red ball details of a two-color ball.

2. Set the number of blue balls

Same as the red ball setting.