Men's lottery procedure is a common situation in our life and work, so it is very important for our work to learn simple decision-making in advance, which is often used.
How to make simple number lottery tickets with Excel tables? Sometimes queuing for lottery in excel requires making number plates, but many people don't know how to make them. The following is a detailed tutorial on making lottery tickets with excel tables. Friends who need it can refer to it.
way
1
/4
Making a simple number lottery system with Excel
1. Create a new blank excel table.
2. Select multiple cells and merge them in the center (this step can be omitted).
2
/4
3. Select a cell, enter the formula = int (rand () * (100-1+1))+1,and press enter to confirm.
Tip:
1) Remember to enter it with the = sign;
2) If it is extracted from 1-50, replace 100 with 50 in the formula, and so on.
three
/4
4. Select a cell and adjust the font size in the Start tab.
four
/4
5. Press F9 to refresh, that is, every time you press F9, a new number will appear.
Tip: Long press F9 has the effect of digital scrolling ~
Matters needing attention
This formula may have repeated numbers in n refreshes.