1 thought on “How to make lottery draw on mobile phone WPS form”
Allan
Step 1: First of all, we determine the previous data. For example, we must display the name of the prizes that are drawn and enter the name of the prize. Please click to enter the picture description Step 2: Then make the interface of the drawing result. Please click Enter the picture description It Step 3: Insert a function in the draw display box, a random function (). Because the award I set is only 6, the value range can be set (1,6) . Please click Enter the picture description Step 4: Because you need to get the name of the prize, you need to insert an index to get the function index (data range, index value). So we can wrap the INDEX function to wrap the random function: INDEX (data range, (1,6)) Please click to enter the picture description Step 5: In order to dynamically display the drawing process, We can highlight the prize name. Select all the prizes names and click the "Outstanding Display Unit Rules" under the "Condition Format" under the "Start" menu. Please click Enter the picture description Step 6: Select "equal" under the "cell rules", and then use the mouse to click the units where the lottery results are. If the results of the lottery are consistent, the prize name is highlighted. Please click to enter the picture description Step 7: After setting, press and hold the F9 key on the keyboard to perform operations. Until the F9 key is released, the draw result will be generated. Please click Enter the picture description Summary: 1, first set the draw name and draw display area 2, first insert the random function in the draw display area (minimum value, maximum value) 3, then wrap a function index (data area, index value) 4, which obtains the index name on the outside of the random function. The condition is the result of the lottery. The process is the data area of the lottery name 6. After setting, press and hold the F9 key for the lottery, and the key is released.
Step 1: First of all, we determine the previous data. For example, we must display the name of the prizes that are drawn and enter the name of the prize.
Please click to enter the picture description
Step 2: Then make the interface of the drawing result.
Please click Enter the picture description
It Step 3: Insert a function in the draw display box, a random function (). Because the award I set is only 6, the value range can be set (1,6) .
Please click Enter the picture description
Step 4: Because you need to get the name of the prize, you need to insert an index to get the function index (data range, index value). So we can wrap the INDEX function to wrap the random function:
INDEX (data range, (1,6))
Please click to enter the picture description
Step 5: In order to dynamically display the drawing process, We can highlight the prize name. Select all the prizes names and click the "Outstanding Display Unit Rules" under the "Condition Format" under the "Start" menu.
Please click Enter the picture description
Step 6: Select "equal" under the "cell rules", and then use the mouse to click the units where the lottery results are. If the results of the lottery are consistent, the prize name is highlighted.
Please click to enter the picture description
Step 7: After setting, press and hold the F9 key on the keyboard to perform operations. Until the F9 key is released, the draw result will be generated.
Please click Enter the picture description
Summary:
1, first set the draw name and draw display area
2, first insert the random function in the draw display area (minimum value, maximum value)
3, then wrap a function index (data area, index value)
4, which obtains the index name on the outside of the random function. The condition is the result of the lottery. The process is the data area of the lottery name
6. After setting, press and hold the F9 key for the lottery, and the key is released.