WPS Spreadsheet could be an alternative to Microsoft Office Excel. It includes 100's of built-in formulas, pivot tables, and more.Today, we will learn the basic usage of the RANDBETWEEN function, which can be used to return a random integer between two specified numbers.

This function is relatively simp data-imgw=800 data-imgh=450 data-src="//res-academy.cache.wpscdn.com/images/3abbceeb9422b1d8de90cc6350af09d7.gif" data-test="skks" style="max-width: 100%; width: 720px; max-height: 405px; height: calc(100vw *(450/800)); text-align:center;" >

What should I do if I  data-imgw=800 data-imgh=450 data-src="//res-academy.cache.wpscdn.com/images/2c36bad0efac717400893ffd8ebed0e8.gif" data-test="skks" style="max-width: 100%; width: 720px; max-height: 405px; height: calc(100vw *(450/800)); text-align:center;" >

Every time we press F9 or perform other editing actions, data with this function will automatically refresh. If we want to fix the randomly generated numerical value, copy and paste the function result as Value.

What interesting things can we do with the RANDBETWEEN function?

Suppose you are in charge of the company's lottery activities at the end of the year. You can use the RANDBETWEEN function and the INDEX function to generate a simple lottery tool.

Its principle is very simple. The INDEX function can return the result according to the given row number and column number. In this scenario, the RANDBETWEEN function can randomly generate the row number.

First, we copy and paste the personnel list of the whole company in column A;Enter the function formula in cell E4: =INDEX, then enter column A in brackets;Then enter a comma followed by RANDBETWEEN (1,60), where the minimum value is 1 and the maximum value is 60, the total number of p data-imgw=800 data-imgh=450 data-src="//res-academy.cache.wpscdn.com/images/8a0b389a7d23e93ea4c75eea7dfbc975.gif" data-test="skks" style="max-width: 100%; width: 720px; max-height: 405px; height: calc(100vw *(450/800)); text-align:center;" >

Long press F9 and the name of the person will appear randomly in the cell.

When we raise our fingers, the lucky winner will be born!