How to make a simple lottery through the RANDBETWEEN Function?

Uploaded time: July 25, 2022 Difficulty Beginner

A free Office suite fully compatible with Microsoft Office

Free Download

How to make a simple lottery through the RANDBETWEEN Function?

How to make a simple lottery through the RANDBETWEEN Function?

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.




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.

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!